Re: ORA-06521: PL/SQL: Error mapping function

On 8 Apr 2006 05:17:27 -0700, "Vladimir M. Zakharychev" <vladimir.zakharychev_at_gmail.com> wrote:

>>create or replace procedure shell(cmd IN varchar2)
>>as external
>>...
>>I still can't see the resultset coming out of the following code -
>>
>>
>>extern "C"__declspec(dllexport) void shell(const char *cmd)
>>{
>> int num = system(cmd);
>>}
>>
>
>And what kind of result set you are expecting from this code?
>It's a PROCEDURE, not a FUNCTION, and it doesn't have any
>OUT arguments, so it doesn't return anything. Or do you mean
>that cmd is not executed?
>
>Hth,
> Vladimir M. Zakharychev
> N-Networks, makers of Dynamic PSP(tm)
> http://www.dynamicpsp.com

Obviously the printf function has output for stdout. Now my guess is stdout for external procedures just equates /dev/null. At least, the procedure is run at the server...

--
Sybrand Bakker, Senior Oracle DBA