Re: SQL*PLUS

From: Valery V. Tsekhmister <valery_tsekhmister_at_hotmail.com>
Date: Fri, 24 Jan 2003 15:59:38 +0300
Message-ID: <b0rgr2$ag3$1@slim.sovintel.ru>

Sorry. The news server truncates previous post:

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:59:38 CST