Sure. You can wrap your pl/sql in a script and execute that script. This way you can capture your return as well.
I am not sure if multiple commands can be run. I doubt it.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
You will have to incorporate that pl/sql script into a shell script, kinda like a "here" script. Search the forum or on the net for examples of an "here".
See this example where Ray describes a "here" script for ftp.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
You will have to incorporate that pl/sql script into a shell script, kinda like a "here" script. Search the forum or on the net for examples of an "here".
See this example where Ray describes a "here" script for ftp.
I was trying to ftp
ftp ServerName --- of database, which I need to connect
and it errors out as unknown host.
I guess its because we have non-login accounts setup. So in this case I will only have the option to create a stored procedure on the database or ask the dba group to create login account (will they wouldn't for sure).
You will have to incorporate that pl/sql script into a shell script, kinda like a "here" script. Search the forum or on the net for examples of an "here".
See this example where Ray describes a "here" script for ftp.
I was trying to ftp
ftp ServerName --- of database, which I need to connect
and it errors out as unknown host.
I guess its because we have non-login accounts setup on the database. So in this case I will only have the option to create a stored procedure on the database or ask the dba group to create login account (which they wouldn't for sure).
Actually, the question should have been, Where the heck did ftp come in from?
This entire thread is to get a pl/sql code working from within datastage. I mentioned a 'here script' and referenced Ray's post where he explains a 'here script' using an ftp example. According to me, thats all that ftp relates to the context of this thread.
I am confused as to why the OP wants to create an ftp connection to talk to the database?
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.