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