PB调用Oracle存储过程的问题,请高手指点,不胜感激!!!!
我在Oracle中定义了一个存储过程,如下:
create or replace procedure p_Database_DropTable is
-- 声明游标
CURSOR curDropTableList Is
Select 'Drop table ' || table_name || ' Cascade Constraints' Drop_tables from User_all_tables;
strdroptable Varchar2(60);
begin
-- 打开游标
Open curDropTableList;
Fetch curDropTableList Into strdroptable;
While curDropTableList%found
Loop
Execute immediate strdroptable;
Fetch curDropTableList Into strdroptable;
End Loop;
-- 关闭游标
Close curDropTableList;
end p_Database_DropTable;
然后我在Pb中声明此存储过程,如下:
Declare procDropTable Procedure For p_Database_DropTable Using SQLCA;
但是我保存时就出现非法,说指令引用“0x00000000“内存,该内存不能为“read",不知道为什么?