php.net |  support |  documentation |  report a bug |  advanced search |  search howto |  statistics |  random bug |  login
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
 [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

Add a Patch

Pull Requests

Add a Pull Request

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-2024 The PHP Group
All rights reserved.
Last updated: Thu May 02 23:01:30 2024 UTC