Re: Urgent
From: Manmohan Mann <m_mann_at_hotmail.com>
Date: Sat, 24 Apr 1999 20:41:46 -0400
Message-ID: <372264CA.10036B1C_at_hotmail.com>
Date: Sat, 24 Apr 1999 20:41:46 -0400
Message-ID: <372264CA.10036B1C_at_hotmail.com>
Hi,
- Try entering a '/' on the empty line. e.g. begin dbms_output.put_line('&var'); end; /
The '/' executes the pl/sql block.
2) In the above sample code, when executed will prompt for a value to use in place of &var.
hth,
Manmohan Mann
Abhimanyu Parasher wrote:
>
> Hi!
> I need some help, if anybody can provide me ? Can anybody tell me, how to run a PL SQL code on SQL prompt? Whenever I try to run it, a new line no. appears & it doesn't run. Another question was about getting an input from User in PL SQL. How can I get an input from a user using PL SQL (I'm not using Forms.)?
>
> This is very urgent.
>
> Please help me.
>
> Thanks
>
> Abhimanyu
>
> --
>
>
>
Received on Sun Apr 25 1999 - 02:41:46 CEST