Howto to fill a (define) variable in sqlplus with an "host" output

[PTameris]

Hi,

I want to fill an sqlplus variable with the output of an external command, but before the connect to a database...

So:

# sqlplus /nolog
sql >!echo $PPID
123456

and now i want to fill (with define?) an variable (let see ospid) with 123456

but how?

Greetings
Peter

 

[sem]

Read it again: you should pass it as a parameter to sql from a shell.
So how about describing your final target? I mean that your task is too exotic to be good solution for anything I may imagine

Regards, Dima

http://seminihin.narod.ru

 

[LKBrwnDBA]

Why not just use a generic account with no privileges (except CREATE SESSION) to generate the unique ID:

SQL>conn guest/guest
SQL>col s new_value sessid
SQL>Select DBMS_SESSION.UNIQUE_SESSION_ID from dual;
-- Now from here sessid is unique!

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb