谢谢!
解决方案 »
- 存储过程条件用in,穿参数进去 查不到数据
- 帮我看看 REF 游标哪里错了? 谢谢啦。
- 怎么安全删除dbf文件
- 急!! 动态SQL问题
- 很诡异的不能建表,紧急求助高手
- 如何建立create和insert表,当表名中有@ + -的时候?
- 怎么启动oracle10g的服务器啊
- 系统数据库维护问题?有详细说明!
- 关于在存储过程中判断是否存在该条纪录以确定是否写或是更新这条纪录失败的问题。
- 动态的创建一个表可是???
- 错误号:ORA-06550;如何获取存储过程中游标型TYPE rcsIMPROVE_AIRLINE IS REF CURSOR;的out参数返回的数据集?
- 定义的 clob 字段类型的数据,在编辑的时候只能增加文字?
-- Equivalent to SQL "ALTER PROCEDURE|FUNCTION|PACKAGE [<schema>.]
-- <name> COMPILE [BODY]". If the named object is this package,
-- or any packages upon which it depends (currently "standard" or
-- "dbms_standard") then the procedure simply returns (since these
-- packages are clearly successfully compiled).
-- Input arguments:
-- type
-- Must be one of "PROCEDURE", "FUNCTION", "PACKAGE", "PACKAGE
-- BODY" or "TRIGGER".
-- schema
-- The schema name. If NULL then use current schema. Case sensitive.
-- name
-- The name of the object. Case sensitive.
-- Exceptions:
-- ORA-20000: Insufficient privileges or object does not exist.
-- ORA-20001: Remote object, cannot compile.
-- ORA-20002: Bad value for object type. Should be one of PACKAGE,
-- PACKAGE BODY, PROCEDURE, FUNCTION, or TRIGGER.