I have a procedure that executes os commands
1) pr_runOsCmd uses java in the internal oracle jvm to host out to the os.
It appends the windows start cmd into the cmd line.
I had it working, my db crashed and now I get an ORA-06531: Reference to uninitialized collection when I try to run it.
FUNCTION fn_exec_cmd(p_shell VARCHAR2,p_cmd VARCHAR2,p_output IN OUT cmd_output) RETURN VARCHAR2 as
LANGUAGE JAVA NAME 'com.utils.OSExecutor.executeCommand(java.lang.String,java.lang.String,oracle.sql.ARRAY) return java.lang.String';
cmd_output is declared in the same schema
CREATE OR REPLACE
type CMD_OUTPUT as table of varchar2(255)
I have granted synonyms, privileges to all the schemas but still cant get it working.
How do I initialize this collection?