Re: SQL*PLUS

Hi !

You can notify sql*plus about this bind variable by doing the following, for example:

• Here you define and assign value to your bind variable: var lines number begin :lines := 123;end; /* (or any plsql Óode) */ /
• Here you re-bind this variable to sql*plus environment: col lines new_v lines select :lines lines from dual;
• Then you simply invoke sql*plus SET command set linesize &lines
• Then you can see recently set value show linesize

Regards !
Valery.

"MCLAUDE" <melanie.claude_at_conix.fr> wrote in message news:7f4951fa.0301240426.5ac9d7a4_at_posting.google.com...
> How, with SQL PLUS use a bind reference in order to define an
> environement variable ?
> set linesize :bind_variable
>
> Thanks
Received on Fri Jan 24 2003 - 06:57:12 CST