Im currently working on a project using a stored procedure to login:

The procedure look as follows:

@ip_user_name vchar(5)
@ip_password vchar (5)
@ip_clientinfo_width int
@ip_clientinfo_depth int
@ip_clientinfo_java vchar
@ip_clientinfo_version vchar
@op_session_id
@op_user_id
@op_user_description
@op_lastsuccsess
@op_last_failed
@op_message
@op_returncode

I need the retrive the @op_session_id in order to add information to
other coumns/procedures.

Im currently using Java/JDBC.. but also how to use the procedure from
prompt would be useful.

Thanks in advance.
Ny Net