Question about the early writing stored procedures-CodePudding

The stored procedure compilation is always have warned, also don't know is there any way to debug
Seek counsel,

Note: the select EXE_POWSHELL (filePathRs) into STS from dual;
EXE_POWSHELL: static function of Java code,

CodePudding user response:

Parameters, only write type, don't write length;

CodePudding user response:

reference 1st floor wmxcn2000 response:

parameter, only write type, don't write length;

well, there are other? I'd like to know how to debug stored procedures, but I baidu results are not solve my problem,

CodePudding user response:

With tools, PLSQL, sqldeveloper can debug

CodePudding user response:

 
- select multiple variable assignment, to write 

SQL> 
SQL> The set serverout on; 
SQL> Declare 
2 v1 int. 
3 v2 int. 
4 the begin 
5 select 1, 2 into v1, v2 from dual; 
6 dbms_output. Put_line (' v1='| | v1 | |' v2='| | v2); 
7 the end; 
8/
V1=1 v2=2 
PL/SQL procedure successfully completed 

SQL>

CodePudding user response:

reference sxq129601 reply: 3/f

with tools, PLSQL, sqldeveloper can debug

wanted to ask how to operate, with Japanese, baidu out options are not corresponding to the

I'm oracle11g

CodePudding user response:

reference 5 floor sinat_30824257 reply:

Quote: refer to the third floor sxq129601 response:

With tools, PLSQL, sqldeveloper can debug

wanted to ask how to operate, with Japanese, baidu out options are not corresponding to the I am oracle11g

The simplest tool is up sqlplus, only is the command line, use up more troublesome,

You can also download the oracle SQL developer, the official download a English version, connected to the database of your company, you can run