hi everyone! im having a problem, i want to display 10 records at a time per page in a cgi page, im using oracle 8 i have try'd a few things without any luck, HELP! i could get all my records fine but i cant get the paging to work. david
-----Original Message----- From: Hamish Whittal [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 05, 2003 4:17 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: DBD::Oracle not executing stored procedure properly... Hi all, I have a stored procedure that is defined as follows: PROCEDURE Add_ComponentDetails( p_ComponentID IN number, p_PollingID IN number, p_Answer IN varchar2, p_ASNNumber IN varchar2) In my perl code, I exec the following: my $plsql_params = "'" . join("', '", $ASNNameHash->{compID}, $pollID,$answer, $asnNum) . "'" ; my $sql = qq{BEGIN DEVICE_MANAGEMENT.ADD_COMPONENTDETAILS($plsql_params); END;}; print qq(\n*****-->$sql<--*****\n) if $debug; $sth = $$dbh->prepare($sql); # End of the prepare $sth->execute(); Now, when I execute program, I produce output and have determined that the SP is being called correctly. Thus, this is from the output of running the code. BEGIN DEVICE_MANAGEMENT.ADD_COMPONENTDETAILS('17', '22', 'pm-16a', '.1.3.6.1.4.1.9.3.6.11.1.2.3'); END; When I submit this in SQLPlus, it works like a bomb, but when submitting it from the perl code above, it does absolutely nothing. I am at a complete loss of why this could be. I am running the following: Oracle9i Enterprise Edition Release 9.2.0.1.0 Perl DBD::Oracle v 1.12 Perl: v5.6.1 built for sun4-solaris Hope someone can shed some light on this one as I have tried many permutations and cannot see what is going on. Thanks in advance. Excuse the cross posting, but I thought some folk on the beginners list might know the answer.... Cheers H -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
