Pablo Ganga

Greenhorn
+ Follow
since Oct 12, 2005
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Pablo Ganga

ok:
I'm trying too use the jsf dataTable to show a list of users with paging.
i'm using the sun implementation i mean the <h:dataTable>
some what like the aspDataGrid.
17 years ago
JSF
i'm very happy about this.
thanks to head first of course
17 years ago
Hi Everyone,
i'm looking for a good jsf DataTable turotial
please can someone tell me about a good one?.
i apreciate your help
17 years ago
JSF
you know, I work in aspx and we use Aplication block Data, and I asked to myself if there any way to obtain the parameters for a stored procedure in jdbc.

in .net it would be like this:

//we get an array of parameters
IDaraParameter[] params = OracleHelper.getParametersSet("Nombre Procedimiento",OracleCOnection).

well i hope you can help me
Congratulations !!!
keep going that way
17 years ago
I Did it last thursday!!!
Now the going for the web !!!
17 years ago

Originally posted by Shailesh Chandra:
<hr></blockquote>


You can use stored procedure in java IFF it works on your DataBase on the first place.

Not sure about SQL Server but if it were oracle the your procedure wouldn't have compiled. It would have given error like INTO clause is expected in this SELECT statement

your procedure shpuld be like



here VAR1,VAR2 are variable defined as COl1 and COl2 type. Also in order to retrun some output from procedure us should have some out arguement to hold output.

If you are planning to return multiple rows from procedure then your out type would be a 'REF CURSOR'


Shailesh[/QB]


that's right the procedure works fine in sql server 2000 but in oracle didn't work.

can you put an example with ref_cursor.
I'm a little green using jdbc.
I have a similar problem mi stored procedure look like this in sqlserver 2000
I can't get any result...