Forum OpenACS Development: ORA-06550:line 3, column 19 + PLS-00201: identifier 'BBOARD

1: ORA-06550:line 3, column 19 + PLS-00201: identifier 'BBOARD_FORUM.NEW' must be declared

Posted by ram P on 04/04/07 02:55 PM

i'm facing this problem when I tried to create a new forum in openacs(debian linux machine). Exact error page looks like this. Can any 1 help me. (dotLRN is not in the machine)

nsoracle.c:3548:ora_tcl_command: error in `OCIStmtExecute ()': ORA-06550: line 3, column 19:
PLS-00201: identifier 'BBOARD_FORUM.NEW' must be declared
ORA-06550: line 3, column 13:
PL/SQL: Statement ignored

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.
..."
.
.
.
.

3: Re: ORA-06550:line 3, column 19 + PLS-00201: identifier 'BBOARD_FORUM.NEW' must be declared (response to 2)

Posted by ram P on 04/04/07 05:22 PM

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.
..."
.
.
.

5: Re: ORA-06550:line 3, column 19 + PLS-00201: identifier 'BBOARD_FORUM.NEW' must be declared (response to 1)

Posted by Dave Bauer on 04/04/07 05:30 PM

There is a new packages called simply Forums that has been available since OpenACS 4.6. I recommend you use that package instead, which is actively maintained.

7: Re: ORA-06550:line 3, column 19 + PLS-00201: identifier 'BBOARD_FORUM.NEW' must be declared (response to 6)

Posted by ram P on 04/04/07 05:42 PM

Mr.Dave Bauer do you have link for simplyForum, I got 1 link in some bookmarks but i can not access that site, system gets slow as soon as i click that link...

Please post the link so that i can use that package for creating forum...

Forum OpenACS Development: ORA-06550:line 3, column 19 + PLS-00201: identifier 'BBOARD_FORUM.NEW' must be declared