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

IP question
ive got 2 ip addresses both global from same user how would i detect if they are local to each other

Multi language - seo links
Im trying to figure out the best method to have a multi language website that will function with seo

How to secure my login data to my database?
Hi there,

It may be a stupid question but I don't know how to secure my login data to my data

Sequre login with cookies.
I want to build secure login with cookies. I just want your ideas about this, your suggestions. What

Multipe Dynamic Controls & AutoPostback Issue
I currently have a need to create many dynamic controls (Example Textboxes) that need to do a PostBa

Include with Parameters
In a particular page I would like to include a file that requires $_GET parameters.

when I go

upload form file types....
Hey all, I am learning PHP and I am writing a script from the W3C Schools tutorials for uploading fi

type check while uploading
Hi Everyone,

How can I check the exact type of a file while uploading on my site?

Here

PHP/Database issue
My friend is helping me make a database where you go to a certain webpage of my site and the page wi

md5 is it unique
I know this is most likely one of many simple questions that can be found semi easily. But I'm press