pl sql developer to debug stored procedures and how to debug stored procedures created package

2010-12-22  来源:本站原创  分类:Database  人气:90 

Learn to use PL / SQL Developer's debugging features for writing complex stored procedures, packages, funtion ... very helpful, so tonight to learn a bit:

(1) Set a breakpoint in the body (want to set a breakpoint in the line began to click the left mouse button).

pl sql developer to debug stored procedures and how to debug stored procedures created package

(2) Right-click on TEST.

pl sql developer to debug stored procedures and how to debug stored procedures created package

Window will appear as follows TEST WINDOWS

pl sql developer to debug stored procedures and how to debug stored procedures created package

Red circle in the location in the following input parameter value field value, because varstr is an input parameter, where to enter a value, but io_cursor the input and output parameters, output parameters are not in this as a pre-entered values

pl sql developer to debug stored procedures and how to debug stored procedures created package

(3) Debug -> Start.

pl sql developer to debug stored procedures and how to debug stored procedures created package

If the above steps in the debug - start can not click on the gray, it is because the user is not assigned to this transfer of authority,

If you click on the words of the implementation pl / sql developer to debug stored procedure error

note: debugging requires the debug connect session system privilege.

The reason is not enough user privileges, use the following command to grant permissions:

Sysdba role with username, use the following command

GRANT debug any procedure, debug connect session TO username

(4) Click the red button for single-frame stepping, the body automatically will jump to the stored procedure.

pl sql developer to debug stored procedures and how to debug stored procedures created package

(5) the mouse into the variable can be shown that the variable value.

pl sql developer to debug stored procedures and how to debug stored procedures created package

You can also right-click the mouse outside the chain of variable selection Add variable to Watches

pl sql developer to debug stored procedures and how to debug stored procedures created package

At this point the next red circle in the value of the variable listed

pl sql developer to debug stored procedures and how to debug stored procedures created package

South Point on the map in bold red button pops up the following dialog box shows details of the variable value

pl sql developer to debug stored procedures and how to debug stored procedures created package

The following is to create a simple stored procedure example

CREATE OR REPLACE PACKAGE u_pg_test as
TYPE t_cursor IS REF CURSOR;
Procedure u_sp_test (varStr varchar2, io_cursor IN OUT t_cursor);
END;

CREATE OR REPLACE PACKAGE BODY u_pg_test AS

Procedure u_sp_test (varStr varchar2, io_cursor IN OUT t_cursor) IS

v_cursor t_cursor;
varSql varchar2 (666);

BEGIN
varSql: = 'Select * aa where ANAME ='''|| varStr ||'''';

OPEN v_cursor FOR varSql;

io_cursor: = v_cursor;

END u_sp_test;

END u_pg_test;

相关文章
  • PL / SQL DEVELOPER basic Detailed description 2010-03-25

    PL / SQL DEVELOPER basic Detailed description (proposal written after the first stored procedure, the initial hand must-read) Used the oracle of all complaints, in order to stabilize its operation to provide graphical slow sad ah, p4 +128 M to start

  • PL / SQL Developer to use 2010-07-29

    PL / SQL DEVELOPER basic Detailed description (proposal written after the first stored procedure, the initial hand must-read) Using PL / SQL is also almost a year, and now find that lots of other good stuff ah. Ha ha Used the oracle of all complaints

  • (R) PL / SQL Developer with skills 2011-01-20

    1, PL / SQL Developer Password Remember me Using PL / SQL Developer, in order to facilitate the work want to PL / SQL Developer Oracle users to remember login name and password; Setting method: PL / SQL Developer 7.1.2 -> tools-> Preferences-> Or

  • pl sql developer How to debug stored procedures in the package to create and debug stored procedures 2010-12-22

    Learn to use PL / SQL Developer's debugging functions, for writing complex stored procedures, packages, funtion ... very helpful, so tonight to learn a bit: (1) set breakpoints in the body (want to set a breakpoint in the line begin to click the left

  • pl sql developer to debug stored procedures and how to debug stored procedures created package 2010-12-22

    Learn to use PL / SQL Developer's debugging features for writing complex stored procedures, packages, funtion ... very helpful, so tonight to learn a bit: (1) Set a breakpoint in the body (want to set a breakpoint in the line began to click the left

  • PL SQL Developer to create stored procedures and problems encountered and solutions 2011-04-22

    1. After login PL SQL Developer , On the left to find the Procedures, right-click pop-up submenu , Click new 2. In the dialog box, enter the stored procedure name and parameter name. Parameter type , Then click OK: 3. Then the stored procedure code i

  • pl / sql developer execute scripts to create stored procedures 2011-09-05

    pl / sql developer to create a stored procedure tips 1.sql script ready sql script editor, when the stored procedure must be added after each ending in "/." (2) the implementation process The script to execute in the command window, or create a

  • SQL * Plus or PL / SQL Developer View stored procedure compile errors 2011-05-27

    SQL * Plus or PL / SQL Developer View stored procedure compile errors In SQL * Plus or PL / SQL Developer in the Command Windows With show errors procedure procedure_name can see the stored procedure specific error With show errors function function_

  • SQL * Plus or PL / SQL Developer to view stored procedure compilation error 2011-05-27

    SQL * Plus or PL / SQL Developer to view stored procedure compilation error In SQL * Plus or PL / SQL Developer in the Command Windows With show errors procedure procedure_name can view the stored procedure specific error Check with show errors funct

  • 使用PL/SQL Developer进行DEBUG时Step into会直接跳过procedure 2012-03-09

    使用PL/SQL Developer的DEBUG功能我们可以很方便的对PL/SQL代码进行逐行跟踪,但今天突然发现不好使了,检查了一下,确保一下两点即可: 1. 不要用sys用户去调试: 2. 编译package时需加入debug信息: alter package t01 compile debug; 原文链接:http://blog.csdn.net/t0nsha/article/details/7012641

  • PL / SQL Developer Tips 2010-04-13

    PL / SQL Developer Tips 1, PL / SQL Developer remember the login password when using PL / SQL Developer, in order to facilitate the work of hope PL / SQL Developer Oracle Remember login user name and password; Set Method: PL / SQL Developer 7.1.2 ->

  • PL / SQL Developer practical skills 2010-07-29

    Oracle database is believed to have a lot of companies build their business-critical support for the importance of the background, is often used by many developers back. However, Oracle provides its own set of client-side tools are not useful, a grea

  • [Transfer] pl / sql developer experience 2011-07-28

    1. PL / SQL Developer remember the login password in the use of PL / SQL Developer, the In order to facilitate the work want to PL / SQL Developer Oracle users to remember login name and password; Setting method: PL / SQL Developer-> tools-> Prefere

  • PL / SQL Developer with skills 2011-07-31

    1, PL / SQL Developer Password Remember me Using PL / SQL Developer, in order to facilitate the work want to PL / SQL Developer Oracle users to remember login name and password; Setting method: PL / SQL Developer 7.1.2 -> tools-> Preferences-> Or

  • Oracle uses the skills and PL / SQL Developer configuration 2010-12-03

    PL / SQL Developer with skills 1, PL / SQL Developer Password Remember me Using PL / SQL Developer, in order to facilitate the work want to PL / SQL Developer Oracle users to remember login name and password; Setting method: PL / SQL Developer 7.1.2

  • PL / SQL Developer commonly used techniques 2011-03-13

    1, PL / SQL Developer Password Remember me Using PL / SQL Developer, in order to facilitate the work want to PL / SQL Developer Oracle users to remember login name and password; Setting method: PL / SQL Developer7.1.2 -> tools-> Preferences-> Ora

  • PL / SQL Developer with skills summary (rpm) 2011-04-24

    The following tips only for PL / SQL Developer 6 or later, version 5 only one part of the property. 1, right-click menu in PL / SQL Developer (below referred to as PLD) in a text editor window for each, such as the SQL Window, Command Window and Porg

  • PL / SQL Developer with skills (turn) 2011-04-25

    1, right-click menu In PL / SQL Developer (below referred to as PLD) in a text editor window for each, such as the SQL Window, Command Window and Porgram Window, right-click an object name will pop up a menu containing the command operation object, w

  • PL / SQL Developer practical techniques (transfer) 2011-06-16

    Oracle database is believed to have become the key to many companies build their own business, an important background support, but also many developers often use the background. However, Oracle provides its own set of client tools are not very good,

  • PL / SQL Developer Plugin for SVN 2010-06-18

    PL / SQL Developer Developer official website provides version control plug-in is the VCS, but the VCS need to rely on other to achieve Microsoft SCC interface version control tool, but the more the project using svn. Therefore, PL / SQL Developer De