Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

ORA-26032: index string.string loading aborted after string keys

2177


ORA-26084: direct path context already finished

1995


ORA-26094: stream format error: input column overflow

2854


ORA-26082: load of overlapping segments on table string.string is not allowed

1815


if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires

2752


ORA-26079: file "string" is not part of table string.string

1999


IMG-02003: 2FF03 - incorrect color histogram feature specification

1760


In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2945


ORA-26095: unprocessed stream data exists

3638


ORA-26027: unique index string.string partition string initially in unusable state

6790


ORA-16627: No standby databases support the overall protection mode.

4036


ORA-26076: cannot set or reset value after direct path structure is allocated

2032


invalid quantity specification negative quantity are not allowed for this item please check this item definition quantity

3436


ORA-16516: The current state is invalid for the attempted operation.

8875


ORA-26029: index string.string partition string initially in unusable state

2229