On Thu, 12 Dec 2002 16:20:21 -0800 (PST) Nanditha Gade <[EMAIL PROTECTED]> wrote:

>   Thanks for the info. But i have a restriction that i
> can't create procedures on the database...

You can do the conversion in an anonymous block that assigns the values to
bind variables.

DECLARE
   o1 object;
BEGIN
   proc1( o1 );
   :b1 := o1.p1;
   :b2 := o1.p2;
END;

-- 
Mac :})
** I normally forward private questions to the appropriate mail list. **
Ask Smarter: http://www.tuxedo.org/~esr/faqs/smart-questions.html
Give a hobbit a fish and he eats fish for a day.
Give a hobbit a ring and he eats fish for an age.


Reply via email to