Hi Reiner,
> when i execute a query against the data that contains the swedish
character
> å i get a ? returned instead.
unfortunately, there are more places where something can get wrong :-(
1. What is your database character set?
(select * from nls_database_parameters where parameter =
'NLS_C
Hi,
> I am using Perl DBI/DBD for Oracle. I have a lot of PL/SQL, and I can't
> find any mention of whether or not Perl DBI can receive Oracle PL/SQL
> structures (PL/SQL tables of type RECORD) back from a call to a PL/SQL
> call.
>
> TYPE t_task_cmd_list IS TABLE OF VARCHAR2(1000)
>
> FUNCTION
Hi,
I think it would be helpful to pass the NativeError as third parameter to
odbc_err_handler.
AFAIK this variable contains the numerical representation of a
error/warning, so it is
more suitable for further processing than regex matching againt the error
string.
patch to the dbdimp.c file is the
Hi,
> I actually mean results sets, multiple rows returned.
> I have had problems with the exact syntax against
> ms sql server all the time, and was worried it is not possible to do it.
> I was able to find more references to Oracle by googling etc but thay
> syntax didn't seem to work for me as
Hi,
> Is there anybody out there that can
> give an example of calling a stored
> proc from within perl and then fetch
> the result set returned by the proc?
Do you mean "result value" (scalar value in terms of perl)
or "result set" (more than one row)?
If you mean "result value" then you can use
Hi there,
yesterday I've got the following problem:
> example:
--- SNIP SNIP
use DBI;
$connection = DBI->connect("DBI:ODBC:mydb", q(user), q(passw));
if(($DBI::err != 0) || !$connection) {
die "not connected!\n";
}
$csr = $connection->prepare("select 1 fro
Hi folks,
the $ora_errno and $ora_errstr variables should contain the error code
and the error string of the last function call to a oracle-OCI function.
Unfortunately, in the oraperl-emulation of DBD::Oracle 1.14 the above
mentioned variables contain the "last" error, regardles of successfully
e
IELD2", then this may create unpredicted
results.
In the enclosed file version.txt you may find my perl-configuration details.
In the enclosed file t2.pl you may find a sample code I've used to reproduce
the error.
Best regards,
Martin Busik
P.S. Please remove the
http://www.wm