HOW to get the bind variables list.

Posted on 16th Feb 2014 07:03 pm by admin

I've the following problem : I've some SQL queries stored in my DB as VARCHAR2 values.
I need to use DBMS_SQL in order to execute them.
In theese SQL statements I have some bind variables like :NUMORD. (ex. SELECT 'X' FROM YYYY WHERE FIELD_1 = :NUMORD).
I don't know "a priori" names and number of such variables.
Is there any way to have a list of such bind variables ?
I found DBMS_DESCRIBE but is seems to act only on stored procedures/functions.
I know I can tray to inspect the code looking for every ':' but a cleaner solution woulf be appreciated.
Tks

Your Answer:

Login to answer

Other forums

getting weird error..
okay, I'm getting an error on this particular function, something about the syntax in the mysql LIMI

Transferring session variables into MySQL
I am trying to transfer $_SESSION variables into MySQL. However there is an error in my MySQL statem

Option box to change variable
Hello, i need help by making a script!

I need to write a file with option box, so a dropdown

Regarding accessing SQL query issued by any user in Oracle 10g
Hi all,
i want to know the queries issued by various users accessing a database...

post to self
Trying to get my form to submit to itself. However I am also trying to use an image for my submit bu

Join Query Help
Hi all,

I am having problems with the below code, which we shall call 'my first join query'!

Error In Syntax
I got this error:

Code: Parse error: syntax error, unexpected '>' in /home/bucket/publ

How to find OS bit version
How can I tell the person browsing my site is running 32, or 64 bit operating system?

Help with echo()
I'm having some problems with this code:

Code: echo '
<A HREF="jav

Multiple Dropdown Selections
I have a form that let's a user insert a page with the ability to select categories. I want them to