2. PHPRunner General questions
  3. oracle blob upload php error
This topic is locked

oracle blob upload php error

 		2/6/2008 4:32:06 PM
PHPRunner General questions
D
 dakk author

I have an oracle blob field in a table. I can insert a pdf or jpg into the database via Oracle sql developer. I have a phpRunner app that is uploading a file into the database. In the visual editor the form field is a FILE type for edit/view. I get the following error when I save.
OCI-Lob::save() [function.OCI-Lob-save]: OCI_INVALID_HANDLE
Non blob data saves fine to the database. Any takers?

Thanks
J
 		Jane 2/7/2008

Hi,
help please zip and send to [email=support@xlinesoft.com]support@xlinesoft.com[/email] the full set of generated PHP files along with your database creation script and project file for investigation.

I'll find what's wrong with your project running it on my test box.
D
 		dakk author 2/7/2008

Thanks Jane, will do.
D
 		dakk author 2/11/2008

Update. phprunner support fixed the problem. I had named the blob field "FILE" which is an Oracle reserved word. Renamed the field and no error. They will fix PHPrunner in the next release for people like me. Thanks support.