| Dynamic Select with parameters [message #36372] |
Thu, 22 November 2001 01:58  |
Mac78
Messages: 1
Registered: November 2001
|
Junior Member |
|
|
Hi to all people.
My english is not very well, because I am from Italy
Well.
My problem is this:
I need to perform a query in a table, but
I want a result from a specific table and a specific
field. How can I use any parameters to do this?
I would to use your script into a stored procedure.
Thank you very much.
Bye
P.s. IT's TOO URGENT!
----------------------------------------------------------------------
|
|
|
|
| Re: Dynamic Select with parameters [message #36375 is a reply to message #36372] |
Thu, 22 November 2001 03:45  |
Nicola Farina
Messages: 63
Registered: October 2001
|
Member |
|
|
Hi Mac78
Have a look at the DBMS_SQL package.
See an example of use below:
CurHandle integer;
..
CurHandle := DBMS_SQL.OPEN_CURSOR;
DBMS_SQL.PARSE(CurHandle,
'DELETE FROM ' || cTempTableName ||
' WHERE CD_CATEGORIA = :CategoriaRichiesta ' ||
' AND ID_RAGGRUPPAMENTO = :IdRaggruppamento ',
DBMS_SQL.V7);
DBMS_SQL.BIND_VARIABLE(CurHandle, ':IdRaggruppamento', IdRaggruppamento);
DBMS_SQL.BIND_VARIABLE(CurHandle, ':CategoriaRichiesta', CategoriaRichiesta);
Result := DBMS_SQL.EXECUTE(CurHandle);
----------------------------------------------------------------------
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
