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

PHP Programming error. Please help!
Hi there,

Am making a website for a friend and have encountered a problem that i need fixing

Remove directories not empty
hi,
i have an array that contains some names (1,4,6,56...). Every integer is a name of a folder.<

Tree Menu
Hi guys,

Can anyone help me making a tree navigation system? I have a site where I'm allowin

a dificult string search
Hi I don't know a way around this. I want the user to input a password, but to make it a bit complca

have trouble in a if condition
The if below is working ok, it check when indexes, name, zipcode and state are empty.
Code: &

BB_Code error
I'm having a problem with a custom built function and keep getting this error:


Warning: M

Form File Upload
I've read through tons of resources and tutorials and as far as I can tell, my code is accurate, but

PHP and XML image gallery variable issue
I'm trying to display the large image on the same page as the thumbnails, to do that I'm passing a v

Error with login script
I am getting an error with my login script:

Error:
Code: Warning: Cannot modify header inf

what are '%S%', '%E%'
for example when i see Code: [Select]printf("Hello %srn", $name);
what does %s means