错在哪里在线等待马上给分

Question

SELECT OBJECT_NAME INTO OBJECT_NAME_TEMP NUMBER  FROM USER_OBJECTS   WHERE OBJETCT_ID = p_id;
                                           *OBJECT_NAME_TEMP NUMBER多了个NUMBER！另外object_name应该是varchar类型，所以应该改为procedure  proc_table_id (p_id IN OUT NUMBER)
IS
OBJECT_NAME_TEMP varchar(120);
BEGIN
--SELECT OBJECT_NAME FROM USER_OBJECTS; 
SELECT OBJECT_NAME INTO OBJECT_NAME_TEMP FROM USER_OBJECTS   WHERE OBJETCT_ID = p_id;END proc_table_id;

Answer 1

SELECT OBJECT_NAME INTO OBJECT_NAME_TEMP NUMBER  FROM USER_OBJECTS   WHERE OBJETCT_ID = p_id;-->
SELECT OBJECT_NAME INTO OBJECT_NAME_TEMP         FROM USER_OBJECTS   WHERE OBJETCT_ID = p_id;

Answer 2

p_id没必要用out型，程序中没返回修改p_id后的值

Answer 3

可是还不对阿
各位老大怎么回事？？
问题肯定出在select 语句上
是不是和全县有关啊？
这么些也不对
procedure  proc_table_id (p_id IN OUT NUMBER)
IS
OBJECT_NAME_TEMP        USER_OBJECTS%ROWTYPE;
BEGIN
--SELECT OBJECT_NAME FROM USER_OBJECTS; 
SELECT * INTO OBJECT_NAME_TEMP FROM .USER_OBJECTS   WHERE OBJETCT_ID = p_id;
--SELECT * from User_objectS;
NULL;END proc_table_id;

Answer 4

错误有两处：SELECT * INTO OBJECT_NAME_TEMP FROM .USER_OBJECTS   WHERE OBJETCT_ID = p_id;
                                    *                        *1.  去掉.USER_OBJECTS前面的. 。
2.  OBJETCT_ID 拼写错误，应该是OBJECT_ID

Answer 5

我靠这么弱智的问题谢谢Lastrop给分