Hi,
I'm using DBI to connect to a remote Oracle Databse Server to execute a procedure. Following is the part of the perl code:
my $dbh=DBI->connect("dbi
racle:host=$_DB_IP;sid=$_DB_SID;port=$_DB_PORT", $_USERNAME, $_PASSWORD, { RaiseError => 1, AutoCommit => 0 });
#create the query
#query to get Siblings of currunt node
eval {
my $child_param = 'navigation/node/:Content#node/content/
rimary_Content_%,Secondary_Content_%,Typography,Relatednode#content/binary/
ata#content/contact/:#content/editorial/:Image,relatedContent_Binary_%,relatedContent_Link_%#content/event/:Link#';
my $parent_param = 'navigation/node/:#node/content/:Content,Node,Promotiontarget_Node#content/binary/rimary_Content_%,Secondary_Content_%#content/promotion/rimary_Content_%,Secondary_Content_%#';
my $test;
my $sth = $dbh->prepare(q{
declare
:test := content_tracer.create_tree('content/binary/data/showcase/broadband/flexible_working',:child_param,arent_param);
end;
} );
$sth->bind_param_inout(":test",\$test,500);
$sth->bind_param(":child_param",$child_param);
$sth->bind_param("arent_param",$parent_param);
$sth->execute();
$sth->finish;
print 'Query Executed....'.localtime().'
';
$dbh->disconnect();
print qq{
};
}
On executing the perl scrip following error is coming:
DBD:racle::st execute failed: ORA-06550: line 10, column 96:
PLS-00553: character set name is not recognized
ORA-06550: line 0, column 0:
PL/SQL: Compilation unit analysis terminated (DBD ERROR: OCIStmtExecute) at sele
ctAll.pl line 43.
Can you please help me with it
thnx
ks
