Results 1 to 4 of 4
  1. #1
    Join Date
    May 2006
    Posts
    5

    Question Unanswered: Stored Procedure- passing 'string'

    Hi-New to Stored procedures here... So far it works -however I need to pass a 'string' of numbers.

    Not sure what to post so I will start with this
    I have the following Arguments...
    SDATE_IN set as a DATE
    EDATE_IN set as a DATE
    MU_IN set as a VARCHAR right now....

    (I am using TOAD to do this)

    My pararemeter code is ....
    DECLARE
    SDATE_IN DATE;
    EDATE_IN DATE;
    MU_IN VARCHAR2(200);
    BEGIN
    SDATE_IN := '1-nov-2006';
    EDATE_IN := '12-nov-2006';
    MU_IN := '617,419';
    VDNMAT.INTERVAL_PROC ( SDATE_IN, EDATE_IN, MU_IN );
    COMMIT;
    END;

    I have highlighted RED what is the problem area.... I want to pass more then one set of numbers, it works FINE if I use just 617, but it could be anywhere from 1 to 12 numbers in my set....

    Help....

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

    Cool


    You may need to change the procedure like this example in Ask Tom.

    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    May 2006
    Posts
    5
    Maybe I should mention I am trying to create this so that I can pass the variables from ACCESS....

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

    Thumbs down

    Quote Originally Posted by prizmguru
    Maybe I should mention I am trying to create this so that I can pass the variables from ACCESS....

    Does not matter, if the VDNMAT.INTERVAL_PROC ( ) procedure uses an IN (...) statement, you would need to modify as per the link I posted.


    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
  •