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

Using loop to count number of entries
I'm writing a program that must ask user to type in numbers. After each entry, the program has to re

ALV List Display to point to another report on Double Click
Hi,

I want my ALV List Display to point to another report on Double Click on its line ite

split string
Hi all

i have some names (imploded by comma):
Code: toronto,paris,madrid
Now, i would

PHP friend keyword equivalent
is there a PHP equivalent for the C++ friend keyword?

value not going in data base
hello friends....
i am having a working javascript....when i am selecting any

Inserting multiple records from single form
I've found a number of threads that deal with this issue, but I'm new to php and coding language so

storing results of a function - previous result overwritten with new result
I have created a function to validate input.

function validate_dimension($value,$name) {
<

Why use interfaces in PHP (OOP)
I am learning OOP in PHP and its been a pretty good learning experience so far. What I didn't unders

New to Arrays
Hi I am new to PHP (a week and a half now) and I am just beginning to read about arrays. I understan

how to load a Sys file with system load and call images?
normally you need register the module as a service with CreateService, and start the service