hello. Please help me!!!
I am sure the Program expression is correct.
but when insert into the news_tbl , if the information for "content" is not too long ,It will work correctly .But when insert a large information (about more than 4000 letter) ,it will :
Warning: OCIStmtExecute: ORA-01704: string literal too long in /htdocs/job/self/add_pub_news.php on line 63
Warning: OCIStmtExecute: ORA-00921: unexpected end of SQL command in /htdocs/job/self/add_pub_news.php on line 104
NEWS_TBL:
CREATE TABLE news_tbl (
id number(11) DEFAULT '0',
content long NOT NULL,
);
SQL:
insert into news_tbl(id ,content) values(2,'$content');
I am sure the Program expression is correct.
but when insert into the news_tbl , if the information for "content" is not too long ,It will work correctly .But when insert a large information (about more than 4000 letter) ,it will :
Warning: OCIStmtExecute: ORA-01704: string literal too long in /htdocs/job/self/add_pub_news.php on line 63
Warning: OCIStmtExecute: ORA-00921: unexpected end of SQL command in /htdocs/job/self/add_pub_news.php on line 104
NEWS_TBL:
CREATE TABLE news_tbl (
id number(11) DEFAULT '0',
content long NOT NULL,
);
SQL:
insert into news_tbl(id ,content) values(2,'$content');