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

confused between ' ' and " "
there is a php i set:
$begin_date_query = mysql_query( "SELECT SUBDATE(due_date, INTERVAL $d

help, header() is not working!
Hello, I have this code:


<?php

/**
* @author samoi
* @copyright 200

How do I replace any number of character occurences with one occurrence?
How do I replace any number of character occurences with one occurrence?

Let's say I have:

Not sure why this script is not working?
Hi I am new to php programing and I was trying to make up a simple script like a captcha but I canno

help with image upload code
Hello,

right now this code I have resizes images and then places them into the uploads folder

shoping cart issues
i´ve wrote this and works when i add an item to, my cart, but when i want to add othrer item just

Problem with passing variables
I'm not really a php programmer so I'm really struggling with this issue.

I have a banner s

need help modifying script
Hi guys,

I'm fairly new to php and am having a bit of trouble modifying a script.

This

Upload simple problem
Really confused!! I run once and it worked, but when i tried today...it didn't work

Which par

check comment for html
hi, I just wanted to check if a comment a user posts contains HTML, and if it does, to not allow it