Recent I have migrated oracle9i to oracle10g(10.2.0.3).
I have nested table that table used user define datatype.
at a column.
when i
want to input the valoue at this column ,i cann't the input
value.following the error messasge i have got:
ORA-24328 illegal attribute value
Hi,
Can anyone help me in solving this error pls.
I am trying to execute a pl script in which it executes a
simple SQL statement "Select Client_loc_no from Subscriber".
I get this error and could not find out the reason why.
" DBD::Oracle::db prepare failed: ORA-24328: illegal
attribute value(DBD ERROR: OCIAttrSet OCI_ATTR_CHARSET_FORM)
[for Statement "SELECT Client_Loc_no from SUBSCRIBER
"] at taskupload.pl line 164."
Given is the code snippet of the script.
---
---
my ($dataSource) = "dbi:Oracle:host=$server;sid=PACD;port=1521";
$dbcdb = DBI->connect($dataSource, $user, $pwd) or die
"Cannot connect to $server using $user/$pwd!\n";
my($sql) = <<EOT
SELECT Client_Loc_no from SUBSCRIBER
EOT
;
my $sth = $dbcdb->prepare($sql) or die "Prepare statement: "
. $dbh->errstr;
--
Is This Answer Correct ? | 0 Yes | 0 No |
ORA-12164: TNS:Sqlnet.fdf file not present
ORA-09937: Chmod of ORACLE password file failed.
ORA-28518: data dictionary translation has illegal translation type
ORA-38747: corrupt before image (file# string, block# string)
ORA-02435: cannot disable unique(string) - unique key not defined for table
ORA-29915: cannot select FOR UPDATE from collection operand
SQL*Loader-00621: Field in data file exceeds maximum length
NZE-29152: SHA-1 self-test failure
ORA-00335: online log string: No log with this number, log does not exist
ORA-14117: partition resides in offlined tablespace
EXP-00073: dump file size too small
NNL-00548: Displays update request statistics