1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Call stored procedure from oracle database 11g in oracle forms developer 6i PL/SQL

Discussion in 'Oracle Forms and Reports' started by pervej.fac, Oct 11, 2014.

  1. pervej.fac

    pervej.fac Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    Location:
    Bangladesh
    Hi dear programmers,
    I have created a procedure in oracle database 11g code are given below

    create or replace package package_ptn is
    procedure PROC_PATIENTREGISTER(PNAME IN PATEINT.PATIENTNAME%TYPE,MOB IN PATEINT.MOBILENO%TYPE,AGE IN PATEINT.AGE%TYPE,GDER IN PATEINT.GENDER%TYPE,BLDGROUP IN PATEINT.BLOODGROUP%TYPE,MRTSTATUS IN PATEINT.MERITALSTATUS%TYPE);
    end package_ptn;

    create or replace package body package_ptn is
    PROCEDURE PROC_PATIENTREGISTER
    (PNAME IN PATEINT.PATIENTNAME%TYPE,MOB IN PATEINT.MOBILENO%TYPE,AGE IN PATEINT.AGE%TYPE,GDER IN PATEINT.GENDER%TYPE,BLDGROUP IN PATEINT.BLOODGROUP%TYPE,MRTSTATUS IN PATEINT.MERITALSTATUS%TYPE)
    AS
    INSERT INTO PATEINT (PATIENTID,PATIENTNAME,MOBILENO,AGE,GENDER,BLOODGROUP,MERITALSTATUS) VALUES(SEQ_PATIENTID.NEXTVAL,PNAME,MOB,AGE,GDER,BLDGROUP,MRTSTATUS);
    COMMIT;
    END PROC_PATIENTREGISTER;
    end package_ptn;

    This code has been successfully run on oracle database 11g.Then I have called this procedure named PROC_PATIENTREGISTER in oracle forms developer 6i PL/SQL ditor.Code are :

    BEGIN
    package_ptn.PROC_PATIENTREGISTER('MUKUL','01712414847',21,'MALE','O+','SINGLE');
    END;

    BUT when i want to compile this code in oracle forms 6i a error is found.Error is :

    PDE-PSD001 could not resolve reference to <Unknown program unit> while loading block P1_10_OCT_201417_36_26.
    Then i have tried to attache library from database.when i click on browse button then another error is found.
    PDE-PLI031 unable to fetch record from table TOOL_MODULE.

    COULD ANYONE PLEASE HELP ME HOW I WILL CALL STORED PROCEDURE FROM ORACLE DATABASE 11G IN ORACLE FORMS DEVELOPER 6I PL/SQL.
    THEN I WILL BE MUCH GRATEFUL TO YOU.

    I WILL WAIT FOR POSITIVE RESPONSE FROM ANYONE.

    THANKS
     
  2. rajenb

    rajenb Forum Expert

    Messages:
    361
    Likes Received:
    114
    Trophy Points:
    655
    Location:
    Mauritius
    Re: Call stored procedure from oracle database 11g in oracle forms developer 6i PL/

    Hi,

    As far as I know, Forms 6i is no longer supported on Oracle 11g.
    Even if most of the your modules might compile, it's not guaranteed that you can migrate or even compile all your applications on 11g; I don't know on which 11g release you are (R1 or R2), but from what I gather, on Oracle 11g R2 you'll even face more issues and no support will be provided by Oracle: they'll recommend you to upgrade to at least Forms 10g or 11g (or downgrade your database !).


    Have a look at the following articles if it helps:

    https://forums.oracle.com/forums/thread.jspa?messageID=10748942#10748942

    http://oracle.ittoolbox.com/groups/technical-functional/oracle-forms-l/form-6i-with-oracle-11g-database-link-4757803