Results 1 to 3 of 3
  1. #1
    vinayakshukre is offline Member
    Join Date
    Jan 2009
    Posts
    2
    Rep Power
    0

    Default Default values of stored procedures

    Is there any document/tutorial about using default values of In parameters of stored procedures of oracle / MS SQL ?

  2. #2
    Join Date
    Jan 2009
    Posts
    14
    Rep Power
    0

    Default

    Hi you can use : paramname default value; Example.
    EMPNO IN number,
    DEPT IN varchar2 default 'CSE' ....


    You can call the procedure using named notation. Example: procedure (empno => 20,dept => 'CSE') etc..

  3. #3
    vinayakshukre is offline Member
    Join Date
    Jan 2009
    Posts
    2
    Rep Power
    0

    Default

    Thanks for taking time on my issue.
    Quote Originally Posted by subrahmanyam.adapa View Post
    You can call the procedure using named notation. Example: procedure (empno => 20,dept => 'CSE') etc..
    This notation surely works from SQLPlus in case of oracle.
    But I want information about using this from Java.
    I have already tried doing this through java as well..but my driver classes12.jar does not support named notation like setInt("param1",10)

    ..thanks.

Similar Threads

  1. Executing stored procedures
    By mew in forum JDBC
    Replies: 3
    Last Post: 08-20-2008, 05:47 PM
  2. Stored Procedures
    By geeta_ravikanti in forum JDBC
    Replies: 1
    Last Post: 04-22-2008, 02:34 AM
  3. Stored Procedures with java
    By Albert in forum JDBC
    Replies: 4
    Last Post: 06-08-2007, 05:59 AM
  4. stored procedures in Hibernate
    By Alan in forum JDBC
    Replies: 2
    Last Post: 05-31-2007, 04:49 PM

Posting Permissions

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