本文共 1779 字，大约阅读时间需要 5 分钟。

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 Connected as scott SQL> var job varchar2(20)SQL> var dname varchar(20)VARCHAR(20) unknown datatype SQL> var job varchar2(20)SQL> var dname varchar2(20)SQL> exec :dname:=get_info('scott',:job); PL/SQL procedure successfully completeddname---------RESEARCHjob---------ANALYST SQL> var r1 numberSQL> var r2 numberSQL> exec :r1:=30 PL/SQL procedure successfully completedr1---------30 SQL> var r1 numberSQL> exec :r1=result(100,:30); begin :r1=result(100,:30); end; ORA-06550: 第 2 行, 第 10 列: PLS-00103: 出现符号 "="在需要下列之一时： := . ( @ % ; indicatorr1--------- SQL> var r1 numberSQL> exec :r1=result(100,30); begin :r1=result(100,30); end; ORA-06550: 第 2 行, 第 10 列: PLS-00103: 出现符号 "="在需要下列之一时： := . ( @ % ; indicatorr1--------- SQL> var r1 numberSQL> var r2 numberSQL> exec :r2:=30 PL/SQL procedure successfully completedr2---------30 SQL> exec :r1:=result(100,:r2); PL/SQL procedure successfully completedr1---------3r2---------10 SQL> col object_name format a20SQL> select object_name,created,status from user_objects  2  where object_type in('PROCEDURE','FUNCTION'); OBJECT_NAME          CREATED     STATUS-------------------- ----------- -------ADD_EMPLOYEE         2012/4/11 下 VALIDQUERY_EMPLOYEE       2012/4/11 下 VALIDCOMPUTE              2012/4/11 下 VALIDGET_USER             2012/4/11 下 VALIDGET_SAL              2012/4/11 下 VALIDGET_INFO             2012/4/11 下 VALIDRESULT               2012/4/11 下 VALID 7 rows selected SQL> SLECT text from user_source where name='raise_salary'; SLECT text from user_source where name='raise_salary' ORA-00900: 无效 SQL 语句 SQL> select text from user_source where name='raise_salary'; TEXT-------------------------------------------------------------------------------- SQL>

转载地址：http://yhzli.baihongyu.com/