system variable in stored procedure
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: system variable in stored procedure

  1. #1
    Join Date
    Jun 2001
    Posts
    31
    Hi everyone,

    I need to know if it is possible to set a unix system variable in a stored procedure.
    could someone give me an example.

    I'm using Oracle 8.1.7 on hp-ux platform.

    Thanks,

    AED

  2. #2
    Join Date
    Sep 2000
    Location
    Sao Paulo,SP,Brazil, Earth, Milky Way
    Posts
    350
    Itīs not possible directly, but you can execute an unix shell-script from your PL/SQL to do the job. To find know to call external programs (shell scripts, OS commands, whatever) search the old messages in this forum, and you find many solutions in 8i , using Java or external procedures.

    []s

    Chiappa

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width