Ok it is working now,
thanks Ugo
yuryx wrote:
> try
> <esql:query><xsp:expr>"create table "+
> tableName</xsp:expr></esql:parameter>
>
> Ugo Cei wrote:
>
>> Gabor Bartha wrote:
>>
>>> Hi all,
>>>
>>> I want to use esql, but I've got problems with <esql:parameter>. It
>>> seems the parameter haven't been replaced by its real value.
>>
>>
>>
>> You cannot have DDL statements with parametrized object names. At
>> least, not in Oracle. Use string concatenation, if you must.
>>
>> Ugo
>>
>>> Here is my xsp, with a java function:
>>>
>>> <xsp:logic>
>>> private String createTable() throws SQLException,
>>> org.xml.sax.SAXException
>>> {
>>> String tableName = "tmp123456";
>>>
>>> //Create table
>>>
>>> <esql:connection>
>>> <esql:driver
>>> transactions="no">oracle.jdbc.OracleDriver</esql:driver>
>>> <esql:dburl>jdbc:oracle:thin:@localhost:1521:OEMREP</esql:dburl>
>>> <esql:username>SCOTT</esql:username>
>>> <esql:password>TIGER</esql:password>
>>> <esql:execute-query>
>>> <esql:query>create table
>>> <esql:parameter><xsp:expr>tableName</xsp:expr></esql:parameter> (id
>>> int not null primary key)</esql:query>
>>> <!--esql:error-results>
>>> <error><esql:get-message/></error>
>>> </esql:error-results-->
>>> </esql:execute-query>
>>> </esql:connection>
>>>
>>> return tableName;
>>> }
>>> </xsp:logic>
>>> ...
>>> ...
>>>
>>>
>>>
>>> When I call the function from the xsp body I've got the following sql
>>> exception:
>>>
>>> Error executing statement: create table ? (cd_id int not null primary
>>> key): java.sql.SQLException:
>>> ORA-00903: invalid table name
>>>
>>> I tried to use the direction="in" with the same result. Any Idea?
>>>
>>> Regards,
>>> Gabor
>>>
>>>
>>>
>>> ---------------------------------------------------------------------
>>> 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]>
>>
>>
>>
>>
>
>
> --
>
> Best regards,
> Yury.
> --
> Yury Mikhienko.
> IT engineer, ZAO "Mobicom-Kavkaz"
>
>
>
>
> ---------------------------------------------------------------------
> 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]>
>
>
> .
>
---------------------------------------------------------------------
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]>
