有这个对象呀!只不对状态老是invalid create or replace procedure System.GetA as begin for cur in( Select * from AgentStatusLog; ) loop dbms_output.put_line(cur.*); endllo end;BEGIN geta; END; * ERROR 位于第 1 行: ORA-06550: 第 1 行, 第 7 列: PLS-00905: 对象 SYSTEM.GETA 无效 ORA-06550: 第 1 行, 第 7 列: PL/SQL: Statement ignored
SQL> create table AA 2 ( 3 AA DATE default sysdate, 4 BB VARCHAR2(10) 5 ) 6 /Table createdSQL> SQL> CREATE OR REPLACE PROCEDURE GetA 2 AS 3 BEGIN 4 for cur in(Select * from aa) LOOP 5 dbms_output.put_line(cur.aa); 6 END LOOP; 7 END geta; 8 /Procedure created 怎么可以出现cur.*呢???
ORA-06550 line string, column string:string Cause A PL/SQL compilation error has occurred. The numbers given for line and column are the location in the PL/SQL block where the error occurred. Action Refer to the following PL/SQL messages for more information about the error.
OracleCommand myCmd=new OracleCommand();
myCmd.CommandType=CommandType.StoredProcedure;
myCmd.CommandText="GetA";
myCmd.Connection=conn;
create or replace procedure System.GetA
as
begin
for cur in(
Select * from AgentStatusLog;
) loop
dbms_output.put_line(cur.*);
endllo
end;BEGIN geta; END; *
ERROR 位于第 1 行:
ORA-06550: 第 1 行, 第 7 列:
PLS-00905: 对象 SYSTEM.GETA 无效
ORA-06550: 第 1 行, 第 7 列:
PL/SQL: Statement ignored
2 (
3 AA DATE default sysdate,
4 BB VARCHAR2(10)
5 )
6 /Table createdSQL>
SQL> CREATE OR REPLACE PROCEDURE GetA
2 AS
3 BEGIN
4 for cur in(Select * from aa) LOOP
5 dbms_output.put_line(cur.aa);
6 END LOOP;
7 END geta;
8 /Procedure created
怎么可以出现cur.*呢???
Action Refer to the following PL/SQL messages for more information about the error.