On 30.Jul.2002 -- 02:37 PM, Frank Taffelt wrote:
> ok second try with:
>
> <esql:call>
> {call sp_get_stocks(<esql:parameter
> direction="in"type="Int"><xsp:expr>20</xsp:expr></esql:parameter>) }
> </esql:call>
> <esql:call-results>
> <esql:row-results>
> <out><esql:get-string column="1"/></out>
> </esql:row-results>
> </esql:call-results>
>
> results in :
>
> Error executing statement: {call sp_get_stocks(?) }: java.sql.SQLException:
> ORA-06550: line 1, column 7:
> PLS-00221: 'SP_GET_STOCKS' is not a procedure or is undefined
> ORA-06550: line 1, column 7:
> PL/SQL: Statement ignored
>
> this error message is confusing, because i have written a small java-jdbc
> applicaion which calls this procedure
> and receives a resultset from it.
Does your code equal (more or less) the one produced by esql?
> any hints ?
Visibility problems, like connection is made using a different user?
Chris.
--
C h r i s t i a n H a u l
[EMAIL PROTECTED]
fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08
---------------------------------------------------------------------
Please check that your question has not already been answered in the
FAQ before posting. <http://xml.apache.org/cocoon/faq/index.html>
To unsubscribe, e-mail: <[EMAIL PROTECTED]>
For additional commands, e-mail: <[EMAIL PROTECTED]>
