Thanks Jim, I could find my last error. Now I have another:
Database operation "dml" failed (exception NSDB, "Query was not a DML or DDL command.")
SQL: insert into mfp_notesi(item_id, revision_id, title) values('3352', '3354', 'Silvia')
while executing
"ns_pg_bind dml nsdb0 { insert into mfp_notesi(item_id, revision_id, title) values(:item_id, :revision_id, :title) }"
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec dml $db $full_statement_name $sql"
MY CODE IS:
{
if { ! [info exists item_id] } {
set item_id[db_nextval acs_object_id_seq]
}
db_transaction {
db_exec_plsql note_insert {select content_item__new(:title,-100,:item_id,null,null,null,null,null,'content_item','mfp_note',:title,null,null,null,null)}
set revision_id [db_nextval acs_object_id_seq]
db_dml revision_add { insert into mfp_notesi(item_id, revision_id, title) values(:item_id, :revision_id, :title) }
db_exec_plsql make_live {
select content_item__set_live_revision(:revision_id)
}
}
return $item_id
}
Thanks before hand,
Silvia
