Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


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



Recent I have migrated oracle9i to oracle10g(10.2.0.3). I have nested table that table used user de..

Answer / premalingam

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

Post New Answer

More Oracle Errors Interview Questions

ORA-16103: Logical Standby apply must be stopped to allow this operation

1 Answers  


PLS-00560: character set mismatch

1 Answers  


ORA-31072: Too many child nodes in XMLType fragment for updateXML

1 Answers  


ORA-12831: Must COMMIT or ROLLBACK after executing INSERT with APPEND hint

1 Answers  


ORA-22869: depth of type dependency hierarchy exceeds maximum limit

1 Answers  






ORA-29908: missing primary invocation for ancillary operator

1 Answers  


KUP-03014: OCI error getting datetime fsprecision.

1 Answers  


ORA-12421: different size binary labels

1 Answers  


ORA-14271: table is not partitioned by Composite Range method

1 Answers  


IMG-00515: incorrect number of input channels

1 Answers  


ORA-31409: one or more values for input parameters are incorrect

1 Answers  


ORA-33058: (XSAGDNGL28) In AGGMAP workspace object, error code string is greater than the maximum error code of number.

1 Answers  






Categories