host out of pl-sql block

[Thiko]

can one host out of a pl-sql block?

e.g.

DECLARE
....
BEGIN
....
IF .... > 0 THEN host run exportscriptfile;
END IF;
COMMIT;
END;
Many Thanks.

Thiko!

 

[Kenrae]

Yes and no.
On NT? Yes.
On Unix? No, but you have a replacement.

What's your platform?

 

[Thiko]

it will be NT (although the server is unix.)

please could you give me a clue on how it can be done on NT. Many Thanks.

Thiko!

 

[Kenrae]

Uhh, Oracle can execute something on its server, not on external servers.
If it's located on a Unix and you want to execute something on a NT server you'll need some sort of communication, between Oracle-NT or between Unix-NT.
If you want to execute something on its server, you need a dinamically linked library (you have them on Solaris or HP-UX machines, at least, err... and NT machines of course). Now I can't explain you all the syntax, but if you search on Oracle web help, you can search for "extproc" and will find it.
If you still have some doubts, don't hesitate to ask me more.

Hope this helps.