Posted By: Buzz_ss Click procedure issue - 09/30/20 05:30 PM
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
Posted By: lost Re: Click procedure issue - 10/01/20 08:35 AM
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.
© Allround Automations forums