Script questions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Script questions

  1. #1
    Join Date
    Mar 2001
    Posts
    286
    1. How do you pass a variable's value from PL/SQL to SQL script?
    2. How do you pass a variable's value from "anonymous " PL/SQL to SQL script?

    3. In SQL, you can execute an OS command by use "HOST." Can you do the same thing in PL/SQL? I mean, how do you run OS commands from PL/SQL?



  2. #2
    Join Date
    Sep 2000
    Posts
    47

    Thumbs up

    1. & 2. I am unable to locate any stright forward solution. You can make use of temp tables. Create a temp table in oracle having 2 cols - col_name and col_value and insert the variable name and it's value in these two cols. And then you can fetch these values from your SQL Script.

    3. This can be worked out by calling an EXTERNAL ROUTINE The required OS command can be stored in a DLL (any routine written in C or C++). . You register the routine in your PL/SQL routine, and then call it to executu your OS command. OR you can even your DBMS_PIPE

    Good Luck,

    Pinakin.

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