[Zope] Follow-up question about calling stored functions with OracleDA

Jim Cain jec@mgmt-inc.com
Thu, 13 Jan 2000 10:10:41 -0500 (EST)


Okay, I've managed to call a stored function. It looks like this:

declare
   new_id number;
begin
   new_id := contact_maint.insert_person
      (
      <dtml-sqlvar first_name type=nb optional>,
      <dtml-sqlvar middle_name type=nb optional>,
      <dtml-sqlvar maiden_name type=nb optional>,
      <dtml-sqlvar last_name type=nb optional>
      );
end;

Now the next question is: How do I return "new_id" so I can refer to it
inside a <dtml-in></dtml-in> call to this SQL method?

Thanks,
Jim