[PHP-DB] how can i set a large String to a xmltype field use PHP?
i can set xml String to xmltype field with:
$sql_insert_sql = insert into g_province
(p_id,p_regionid,p_provincenameobj,solt)
values
(g_province_q.nextval,'.$_GET['region_id'].',sys.XMLTYPE.createXML('.$xml
_con.'),0);
but if $xml_con too long,i can not set this content into xmltype fields.
then , i use :
?
/*
//(tabel_name:articles)DDL; //just for test;
//create table articles (id number(11),content sys.xmltype);
*/
//--This is insert test--
$conn = @OCILogon(in_user,user_in,bigfish);
$stmt = @OCIParse($conn,insert into articles (id,content)
values(1,xmltype(EMPTY_CLOB())) RETURNING content INTO:CONTENT);
$clob = @OCINewDescriptor($conn,OCI_D_LOB);
OCIBindByName($stmt,':CONTENT',$clob,1,OCI_B_CLOB);
OCIExecute($stmt,OCI_DEFAULT);
if ($clob-save(rootaJUST TEST/a/root)){
OCICommit($conn);
echo Insert succes!;
}
else{
echo Insert default!;
}
//---Insert end-
//---Select start---
$sql = select content from articles order by id desc;
$stmt = @OCIParse($conn,$sql);
@OCIExecute($stmt,OCI_DEFAULT);
@OCIFetchInto($stmt,$rows,OCI_RETURN_LOBS);
echo brContent is:\.$rows[0].\;
//---Select end-
?
**
run it ,display these errors:
Warning: ociexecute(): OCIStmtExecute: ORA-22816: unsupported feature with
RETURNING clause in /home/www/bigfish/sgtest/testclob.php on line 12
Warning: save(): OCILobWrite: OCI_INVALID_HANDLE in
/home/www/bigfish/sgtest/testclob.php on line 13
Insert default!
Content is:
Warning: Unknown(): _oci_close_session: OCISessionEnd: ORA-00600: internal
error code, arguments: [729], [28], [space leak], [], [], [], [], [] in
Unknown on line 0
how can i set long content to xmltype fields??
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] how can i set a large String to a xmltype field use PHP?
i can set xml String to xmltype field with:
$sql_insert_sql = insert into g_province
(p_id,p_regionid,p_provincenameobj,solt)
values
(g_province_q.nextval,'.$_GET['region_id'].',sys.XMLTYPE.createXML('.$xml
_con.'),0);
but if $xml_con too long,i can not set this content into xmltype fields.
then , i use :
?
/*
//(tabel_name:articles)DDL; //just for test;
//create table articles (id number(11),content sys.xmltype);
*/
//--This is insert test--
$conn = @OCILogon(in_user,user_in,bigfish);
$stmt = @OCIParse($conn,insert into articles (id,content)
values(1,xmltype(EMPTY_CLOB())) RETURNING content INTO:CONTENT);
$clob = @OCINewDescriptor($conn,OCI_D_LOB);
OCIBindByName($stmt,':CONTENT',$clob,1,OCI_B_CLOB);
OCIExecute($stmt,OCI_DEFAULT);
if ($clob-save(rootaJUST TEST/a/root)){
OCICommit($conn);
echo Insert succes!;
}
else{
echo Insert default!;
}
//---Insert end-
//---Select start---
$sql = select content from articles order by id desc;
$stmt = @OCIParse($conn,$sql);
@OCIExecute($stmt,OCI_DEFAULT);
@OCIFetchInto($stmt,$rows,OCI_RETURN_LOBS);
echo brContent is:\.$rows[0].\;
//---Select end-
?
**
run it ,display these errors:
Warning: ociexecute(): OCIStmtExecute: ORA-22816: unsupported feature with
RETURNING clause in /home/www/bigfish/sgtest/testclob.php on line 12
Warning: save(): OCILobWrite: OCI_INVALID_HANDLE in
/home/www/bigfish/sgtest/testclob.php on line 13
Insert default!
Content is:
Warning: Unknown(): _oci_close_session: OCISessionEnd: ORA-00600: internal
error code, arguments: [729], [28], [space leak], [], [], [], [], [] in
Unknown on line 0
how can i set long content to xmltype fields??
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: oci8
hi, what is your php OS? and what is your oracle OS? Joe [EMAIL PROTECTED] дÈëÓʼþ news:[EMAIL PROTECTED] I am facing problem in connecting to Oracle from php. I followed the instructions listed in www.oracle.com/technology/tech/opensource/php/apache/inst_php_apache_linux.h tml. However, when I run phpinfo(), it show that oci8 is not loaded and eventually the ocilogon() is not working. I'd really appreciate your feedback -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: php v jsp
hi i think php is a fast develop tools for you and jsp is for team work. if you only user jsp , it is be of no concern ,because jsp is sames like php or asp,if you use jsp i suggest you to use strust or servlet Vikas Nanda [EMAIL PROTECTED] news:[EMAIL PROTECTED] Hi I just wanted to know what the advantages are of using php against jsp. My supervisor wants me to use jsp but I think that php might be better. Also can php code be easy reused like jsp? Many thanks all Vikas - Moving house? Beach bar in Thailand? New Wardrobe? Win £10k with Yahoo! Mail to make your dream a reality. -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: How can I store Images in the MySQL Database
i sugest it too. Daniel Kummer [EMAIL PROTECTED] news:[EMAIL PROTECTED] Nikhil Mulley wrote: Hi Lists , My Query is How Can I store Images in the MySQL Database , and how to Index them , can anybosy help me on this please I am starting out a Online Photo Gallery and want to share them , and I want to make the search available, Does anybody has already done on this ? Please help me in this. Regards, Nikhil. How about just storing the server-path in the database and accessing the images over the file system? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Re: PHP vs ASP
asp is not safe because asp only run in windows. Matthew Perry [EMAIL PROTECTED] дÈëÓʼþ news:[EMAIL PROTECTED] I need some ammo to convince my boss not to use ASP but use PHP instead. Anyone have some info I can give him? - Matthew -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: PHP vs ASP
On Sat, 2004-11-27 at 19:57 +0800, javagen wrote: asp is not safe because asp only run in windows. Matthew Perry [EMAIL PROTECTED] news:[EMAIL PROTECTED] I need some ammo to convince my boss not to use ASP but use PHP instead. Appeal to his budget. php + mysql (Both will run on either Windows or linux) costs $0. ASP comes with windows IIS server, but your database costs a lot more! $5000 for the MS SQL server 1 processor license, which you'd need to run a web application (MS has changed the wording of it's MS SQL server twice in the last 4 years). -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP-DB] Re: PHP vs ASP
Take a look at: http://www.oracle.com/technology/pub/articles/hull_asp.html Regards, Bruno B B Magalhães -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] PHPMysqlAdmin
Where can you get PHPmysqladmin? I would like to load it on my test server to make updating and entering Mysql data easier. Thanks for your help! Tim
RE: [PHP-DB] PHPMysqlAdmin
Sourceforge... http://sourceforge.net/projects/phpmyadmin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, November 27, 2004 1:28 PM To: PHP DB Subject: [PHP-DB] PHPMysqlAdmin Where can you get PHPmysqladmin? I would like to load it on my test server to make updating and entering Mysql data easier. Thanks for your help! Tim -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] fatal error
i had created an inventory management system in php using sqlite DB..with ADD,DELETE,UPDATE,VIEW,FIND functions...and it was working properly..but suddenly it is giving an error as Fatal error: Call to undefined function: sqlite_open() in /home/saravall/.HTML/view.php on line 25 can anyone figure out the error.. thanks in advance.. --regards - Do you Yahoo!? Read only the mail you want - Yahoo! Mail SpamGuard.
Re: [PHP-DB] fatal error
how do i remove myself off this list? -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Uploading a db
What is a good way to load a database which I have served in a sql file (with all the sql statements etc). I have tried a GUI called Mascon, and a terminal command mysql -u user -ppassword db_name file.sql with no luck due to various errors, including too large packet size, need reload privilege and authorisation problems. I was hoping to avoid trying to extract it all and insert all the records. Should I be looking at PHPMySQLAdmin or is that only for Administrators (I am a user on a shared internet server). John -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] number format
hello, may pls. suggest me how i can retreive number before decimal and after decimal. for example 123456.7. I want to store 123456 in a variable and 7 in another. also how can i force the user by validations so that he can only enter data in this format only i.e. 123456.7. thanks with best wishes balwant -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
[PHP-DB] Is there any replication service for MySQL?
Hi all, Do you know any replicator server to synchronize database on local server with my web server? Sadeq Naqashzade Yazdi www.Sadeq.ir -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
