OraFAQ Forum: Unix » Accessing bind variables in the UNIX

Home » Infrastructure » Unix » Accessing bind variables in the UNIX (Unix solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Accessing bind variables in the UNIX [message #648417]

Tue, 23 February 2016 04:19

pointers
Messages: 451
Registered: May 2008

Senior Member

Hi,

I've couple of bind variables which hold file names, can you please suggest if there is a way to access these bind variables in the unix
environment.

I can think of ways using here (<EOF) document but is there a way without using here documents.

Regards,
Pointers

Report message to a moderator

Re: Accessing bind variables in the UNIX [message #648425 is a reply to message #648417]

Tue, 23 February 2016 05:22

Michel Cadot
Messages: 68761
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

The only way it to make them output in SQL*Plus.
Something like:

Code: [Select all] [Show/ hide]

$ myvar=`sqlplus <<EOF
set heading on feedback off echo off pagesize 1000 lines 32767 trimout on verify off termout on tab off
select 1 from dual;
select 2 from dual;
...
exit
EOF`
$ var1=`echo $myvar | head -1`
$ var2=`echo $myvar | head -2 | tail -1`
...

Report message to a moderator

Previous Topic:	Hide files from underprivileged users
Next Topic:	Please help me in using case sensitive command

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jun 28 19:30:53 CDT 2025