Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2013
    Posts
    46

    Unanswered: Oracle call stored procedure using characters and quotes for a parameter

    I am trying to call a procedure like this:

    Code:
    call USP_PREPARE_BATCH(100000,'TABLEA','TABLEB','COLUMNA','('01','02','03')','ID');
    There are total 6 parameters and the 5th parameter will be used in the IN clause in a dynamic sql:
    Code:
    WHERE SOME_COLUMN IN
    Datatypes:

    Code:
    create or replace 
    PROCEDURE         USP_PREPARE_BATCH(
    in_source_batch_size    IN NUMBER, 
    in_table_a              IN VARCHAR2, 
    in_table_b          IN VARCHAR2,
    in_external_id          IN VARCHAR2,
    in_mode         IN VARCHAR2,
    in_sort_criteria    IN VARCHAR2)
    If this is possible, please suggest the right way!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Sep 2013
    Posts
    46
    Hi, I have resolved the issue using double quotes instead of single:

    Code:
    call USP_PREPARE_BATCH(100000,'TABLEA','TABLEB','COLUMNA','(''01'',''02'',''03'')','ID');

Tags for this Thread

Posting Permissions

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