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

Sessions Value Not Saved
Hi,

Im making a login form and im using this code:
Code: if($login=="true"){

Material xxx does not exist in plant xxx
Dear All,

I am working for a steel project which is repetitive manufacturing.

script and html conflict in trying to create a header.
I have an error is occurring because of an html webpage with a "php require" at the top of

CODE NOT WORKING
Code: [Select]<?php
//include shared codes

include '../lib/common.php';
include

How to get all server headers like Live http Headers does
Hey all, like many of you I use the Firefox addon "Live http Headers". I'm trying to write

how can i make a .gif images for my site
Dear Friends ,

Pls solve my problem , I am starting making new site but i dont know how can i

php or sql?
Sorry not sure if this is a sql problem or php the following code is supposed to delete data from th

Blocking video streaming
Hello everyone,

I post a message here because i didn't find any solution yet.
I just finis

values in array being escaped
I would like to submit some values - back to the same form for checking before processing...

Consuming third party Payment Gateway API from Procedure.
Hi All,

First of all i would like to thank all the people of the oracle forum for providi