binding tables

Alex Nickolaenkov 06.04.2006 21:13

люди, как привязать таблицу к запросу?

^connect[$SQL.connect-string]{
$res[
		$.returning_value[^table::create{result}]
]
^void:sql{
begin 

select Get_Simple_Field_as_Clob(docid, 'TITLE', 'WEB_SOURCE')
	into :returning_value
	from (select document_id docid
		from documents_tree
		where dockind_id = PKG_ID_CACHE.Get_Kind_ID('WEB_SOURCE')
		and rownum=1
)^;	
end^;
}[
	$.bind[$res]
]}

ORA-01008: не все переменные привязаны (execute, -1)
begin select Get_Simple_Field_as_Clob(docid, 'TITLE', 'WEB_SOURCE') into :my_table.data from (select document_id docid from documents_tree where dockind_id = PKG_ID_CACHE.Get_Kind_ID('WEB_SOURCE') ); end;

---