Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Jordan
    Posts
    137

    Red face Unanswered: Pass collection from Forms to DB-Procedure

    I am using Oracle 9i and forms 6i.

    I have a collection defined (in Database) as below-

    TYPE C_TYPE AS OBJECT
    (clnt_c VARCHAR2(10),
    clnt_did NUMBER);

    CREATE OR REPLACE
    TYPE c_list As table of C_TYPE ;

    And a DB-function in which the above collection is passed as a parameter


    FUNCTION f1(cpc_tab c_list) RETURN VARCHAR2 IS
    begin
    pla pla pla
    end;

    Every thing is working fine but when I tried to
    use this collection and the function via FORMS6i it gives me error.

    Are there any way to pass collection from Forms6i to DB-Proceduer ?


    thanx in advance

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Wink Bad code.

    Quote Originally Posted by giggs11 View Post
    I am using Oracle 9i and forms 6i.

    I have a collection defined (in Database) as below-

    TYPE C_TYPE AS OBJECT
    (clnt_c VARCHAR2(10),
    clnt_did NUMBER);

    CREATE OR REPLACE
    TYPE c_list As table of C_TYPE ;

    And a DB-function in which the above collection is passed as a parameter


    FUNCTION f1(cpc_tab c_list) RETURN VARCHAR2 IS
    begin
    pla pla pla
    end;

    Every thing is working fine but when I tried to
    use this collection and the function via FORMS6i it gives me error.

    Are there any way to pass collection from Forms6i to DB-Proceduer ?


    thanx in advance
    Maybe it's because your function returns a varchar2 instead of a collection.

    What errors do you get?
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •