I executed the package BBOARD_FORUM again, my error has been changed but its stillpointing to same line of nsoracle.c
can u guide me furthur so that i can create a new forum...error look like this....
nsoracle.c:3548:ora_tcl_command: error in `OCIStmtExecute ()': ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at line 3
SQL:
begin
:1 := bboard_forum.new (
forum_id => :forum_id,
short_name => :short_name,
charter => :charter,
moderated_p => :moderated_p,
bboard_id => :bboard_id,
context_id => :context_id,
creation_user => :creation_user,
creation_ip => :creation_ip
);
end;
while executing
"ns_ora exec_plsql_bind nsdb0 {
begin
:1 := bboard_forum.new (
forum_id => :forum_id,
short_name =>..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_ora $type $db $sql] $args"
("oracle" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec exec_plsql_bind $db $full_statement_name $sql 2 1 """
invoked from within
"if { [regexp {:1} $test_sql] } {
return [db_exec exec_plsql_bind $db $full_statement_name $sql 2 1 ""]
} else {
..."
("uplevel" body line 5)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
# Right now, use :1 as the output value if it occurs in the statement,
# or not otherwise.
..."
.
.
.