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

Which PHP-Editor do you think is the best?
Hi everyone,
Myself Brian Anderson. For the last 2 years i have been working a

registration form
first time posting. did some searches but didnt find exactly what i am looking for. dont flame cause

How to schedule the a job?
Hi,
I have prepared a task ( i.e. a procedure is prepare the file and send the same to con

data type in column definition
Hi,
I create a table with column called "Direction of Travel code ".
The travel codes in t

gettext translates ALWAYS?
I'm using gettext with the new version of XAMPP (5.3.0) on Windows Seven RTM (build 7600)
gettext

max function question
Hi All
Ihave a table that holds shipment numbers and dates like this

select * from

Change Age automatically
hi guys . im new to php , is it possible to change age value in mysql automatically when year change

Hashing?
Hi, I was hoping to take a string value then convert it - consistently - across each of our pages in

Getting a variable to work in function params
I have this fuction which is inside a class:

Code: public static function generateEmbedCode($

image upload script not working with png
The basic process of this php code is to take the submitted file, convert it to a small JPG thumbnai