Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    1,074

    Unanswered: Am I using a bind variable

    If I have a package body like the following. Is p_num considered a bind variable in this situation, or should I be rewriting this:

    CREATE PACKAGE BODY dummy_pg
    AS

    PROCEDURE do_something(p_in IN NUMBER)
    IS
    CURSOR conn_csr (p_num VARCHAR2) IS
    SELECT *
    FROM dual
    WHERE 1 = p_num;

    search_num number;
    BEGIN
    FOR user_rec IN conn_csr(p_in) LOOP
    --do something
    END LOOP;
    END;
    END;

    -Chuck

  2. #2
    Join Date
    Sep 2004
    Location
    London, UK
    Posts
    565
    Yes, that's a bind variable.

Posting Permissions

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