denzil_cactus has asked for the wisdom of the Perl Monks concerning the following question:
------------------------------- but its giving me the error$dbh->func( 1000000, 'dbms_output_enable' ); $user_location = "NYC"; $sth = $dbh->prepare(q{ DECLARE name VARCHAR2(50); address1 VARCHAR2(50); address2 VARCHAR2(50); address3 VARCHAR2(50); phone VARCHAR2(50); fax VARCHAR2(50); fax1 VARCHAR2(50); BEGIN select name, address1, address2, address3 || ' ' || state || ' ' || zip_cnty, 'PHONE: ' || telephone, 'FAX: ' || +fax, fax || '.' into name, address1, address2, address3, phone, fax, fax1 from custdata2 where custdata2.code = $user_location; dbms_output.put_line('The value is '||name); END; }); $sth->execute; $dbh->func( $date_string, 'dbms_output_put' ); $values = $dbh->func('dbms_output_get' ); $sth->finish; print "Returned $values \n";
Please suggestDBD::Oracle::st execute failed: ORA-06550: line 43, column 33: PL/SQL: ORA-00911: invalid character
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re: Problem in passing value to a PL/SQL block
by almut (Canon) on Jul 11, 2007 at 09:28 UTC | |
by denzil_cactus (Sexton) on Jul 11, 2007 at 10:20 UTC | |
|
Re: Problem in passing value to a PL/SQL block
by wind (Priest) on Jul 11, 2007 at 10:05 UTC |