contoh nak panggil package procedure dari oracle
contoh ini akan tarik query... so processing adalah dari database server bukan web server... jimattttttt
create or replace
package test_sel_query
as
type cursorType
is ref cursor;
function test_func
return cursorType;
end;
/
create or replace
package body test_sel_query
as
function test_func
return cursorType
as
cursor_v cursorType;
begin
/*
Put whatever SQL and/or processing here.
I use the Oracle dictionary table
...
