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]>
