Print Thread
Click procedure issue
#62071 09/30/20 05:30 PM
Joined: Jun 2018
Posts: 46
Ukraine, Odessa
B
Buzz_ss Offline OP
Member
OP Offline
Member
B
Joined: Jun 2018
Posts: 46
Ukraine, Odessa
Hello

I have found a little issue.
Suppose I have next code :


SQL Query
create or replace package body TEST_SCHEMA.SAMPLE is

 procedure SampleTest
 is
 begin
    SampleTest;
    SAMPLE.SampleTest;
    TEST_SCHEMA.SAMPLE.SampleTest;
 end;
 end SAMPLE;

When I click the first and second lines I get the expected result. Cursor jumps to "procedure SampleTest" line in the same window.
But when I click to "TEST_SCHEMA.SAMPLE.SampleTest;" PLD opens new window and cursor jumps there. It is annoying...
Could You fix it?

Thanks


Sergiy Buzadzhi
Re: Click procedure issue
Buzz_ss #62072 10/01/20 08:35 AM
Joined: Jun 2015
Posts: 72
Russia
L
Member
Offline
Member
L
Joined: Jun 2015
Posts: 72
Russia
It seems, same issue:
SQL Query
CREATE OR REPLACE PACKAGE BODY START_PROCESS IS

FUNCTION WORKING(nTYPE IN NUMBER, nTYPEWORKS IN NUMBER, nBRANCH IN NUMBER, nREFERENCE IN NUMBER, cParam IN VARCHAR2, TYPEMSG IN OUT NUMBER) RETURN VARCHAR2  IS
    cResult VARCHAR2(2000);

    CURSOR read_acc(pClient NUMBER,bClient NUMBER, pContract NUMBER, bContract NUMBER) IS
    SELECT * FROM ACCOUNT
    WHERE CLIENT = pClient AND BRANCH_CLIENT = bClient
    AND CONTRACT = pContract AND BRANCH_CONTRACT = bContract;
BEGIN
      cResult := PCONTRACT.CLOSE_CONT(nBRANCH, nREFERENCE,  GLOBALS.USERID, TO_NUMBER(cParam));
END;

END;

when Ctrl+RClick on PCONTRACT.CLOSE_CONT, cursor move to pContract in cursor definition.

Last edited by lost; 10/01/20 08:37 AM.

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.035s Queries: 15 (0.014s) Memory: 2.5001 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-10 11:16:51 UTC
Valid HTML 5 and Valid CSS