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

How would I protect......
I have a from, actually, a good amount of forms. How can I make it so you can't type the characters:

generate seo frienly url from a text like wordpress
Convert: "åäö" to "aao", "space" to "-", "!?&q

help with email script...
hey

I need help with my mail script

when the form on http://www.mcgdesignstudio.com/c

Get content from table into a list, without repeating.
Alright this is kinda an odd thing, so I need some help.

I have a table "quote" wit

Functions Not Loading Into Div
I had some help doing some of this but what I'm trying to do is get my functions to retrieve its val

Filtering Tables
Hello Thanks for any help any one can give Im very new to PHP..

I need to pull data for clien

Packet Design
Hi All,
Im new about network programming and I want to design a protocol but I have some question

Need help in Generating Combinations
Need help generating all possible combination of names in an array

Lets say i have the follow

Code error with Index.php
Error: Parse error: syntax error, unexpected T_STRING, expecting ',' or ';' in /home/runevid/public_

Xml parsing
I need a suggestion about parsing xml with multiply parts like pervious...
i.e. different device