Re: Assigning Bind Variables to Substitution Variables in PL/SQL

From: HansF <News.Hans_at_telus.net>
Date: Sun, 06 Nov 2005 00:50:07 GMT
Message-Id: <pan.2005.11.06.00.50.07.475281@telus.net>

SQL> variable this_dbis number
SQL> begin

  2    select dbid                      
  3      into :this_dbis
  4      from v$database;

  5 end;
  6 /

PL/SQL procedure successfully completed.

SQL> print this_dbis

 THIS_DBIS

---

2454348050

SQL> define mydbid=:this_dbis
SQL> print &mydbid

 THIS_DBIS

---

2454348050

SQL> But that's not quite what you intend ... time to hit the manuals again?

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting relies guarantees I won't respond. ***

Received on Sat Nov 05 2005 - 18:50:07 CST