passing clob values to stored procedures
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: passing clob values to stored procedures

  1. #1
    Join Date
    Dec 2002
    Posts
    110

    passing clob values to stored procedures

    Hi All

    We have a stored procedure which takes a clob as input parameter in 817 database.
    How do i assign a value to the clob column in a plsql block & call the stored procedure.

    when i try to assign a value to a clob variable in a plsql block it gives the follwing error
    PLS-00382: expression is of wrong type


    Regrds
    Sushant

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,021
    I have a procedure that gets called within a package. It is only declared in the package body so it can only get called from within the package. I;m not sure if it will work as a stand alone.


    PROCEDURE proc_a(
    p_clob IN OUT NOCOPY CLOB)
    AS
    ...
    BEGIN
    ...
    END;

Posting Permissions

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


Click Here to Expand Forum to Full Width