php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login

go to bug id or search bugs for

Bug #24776 dos style EOLs sent to oracle, breaking pl/sql
Submitted: 2003-07-23 14:58 UTC Modified: 2003-07-23 17:50 UTC
From: bliberma at eesus dot jnj dot com Assigned:
Status: Not a bug Package: OCI8 related
PHP Version: 4.3.1 OS: win2000
Private report: No CVE-ID: None
View Developer Edit
Welcome back! If you're the original bug submitter, here's where you can edit the bug or add additional notes.
If you forgot your password, you can retrieve your password here.
Password:
Status:
Package:
Bug Type:
Summary:
From: bliberma at eesus dot jnj dot com
New email:
PHP Version: OS:

 

 [2003-07-23 14:58 UTC] bliberma at eesus dot jnj dot com 
Description:
------------
When a php source file is in msdos format (native format for win2000), the EOL (CR/LF) is sent intact to oracle.  This seems to be ok for vanilla SQL, but it breaks PL/SQL.  The same thing happens under HP/UX when the php source file is in msdos format (but since this is a non-native, perhaps it isn't a bug in this case).  I am using the binary supplied by php.net (running as a cgi).  Here is the actual error produced:

ORA-06550: line 1, column 18: PLS-00103: Encountered the symbol "" when expecting one of the following: begin declare exit for goto if loop mod null pragma raise return select update while << close current delete fetch lock insert open rollback savepoint set sql execute commit forall The symbol "" was ignored.

Transforming the source file from msdos format to unix format eliminates the error.

Patches

Pull Requests

History

AllCommentsChangesGit/SVN commitsRelated reports
 [2003-07-23 17:50 UTC] edink@php.net 
If you use multi-line strings they contain line endings of the php file itself. Not a bug.
 
PHP Copyright © 2001-2025 The PHP Group
All rights reserved. 		Last updated: Fri May 09 21:01:27 2025 UTC