ORA-06550: 第 1 行, 第 7 列: PLS-00905: 对象 SYSTEM.GETA 无效 ORA-06550: 第 1 行, 第 7 列: PL/SQL: Statement ignored

[javaname69]

ORA-06550: 第 1 行, 第 7 列: PLS-00905: 对象 SYSTEM.GETA 无效 ORA-06550: 第 1 行, 第 7 列: PL/SQL: Statement ignored

[javaname69]

ORA-00936: 缺少表达式

[javaname69]

up

[常遇道]

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.

[javaname69]

OracleConnection conn=new OracleConnection(GetData.MyConnectionString);
OracleCommand myCmd=new OracleCommand();
myCmd.CommandType=CommandType.StoredProcedure;
myCmd.CommandText="GetA";
myCmd.Connection=conn;

[子陌红尘]

没有 SYSTEM.GETA 这个对象。

[javaname69]

up

[javaname69]

有这个对象呀！只不对状态老是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

[javaname69]

up

[zhpsam109]

SQL> create table AA
2 (
3 AA DATE default sysdate,
4 BB VARCHAR2(10)
5 )
6 /

Table created

SQL>
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.*呢？？？