Skip to Main Content

DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Trouble with inserting a string containing a single quote

404759Sep 24 2003 — edited Oct 8 2003
Using php with Oracle

If I do the following two lines before sending my $Query string through the parse function

$name = "Dominick's";
$Query = "INSERT INTO customers (name) values ('$name')";

it gives me the following error:

Warning: Ora_Parse failed (ORA-00917: missing comma -- while processing OCI function OPARSE)

If I try and force the single quote to be surrounded by double quotes and therefore not be confused:

$name = "Dominick's";
Query = "INSERT INTO customers (name) values (\"$name\")";

Trying that yields the following error:

Warning: Ora_Parse failed (ORA-01741: illegal zero-length identifier -- while processing OCI function OPARSE)

Help

Jeff

Comments

2909966

We are having the same problem but only on some computers.  I have an iMac running Yosemite v10.10.2 and I get a coffee cup icon when I install our app through Java Web Start.  However, my friend who has a MacBook Pro also running Yosemite v10.10.2 gets the correct icon.  We are both running Java 8 Update 40.

jlanawalt

Is the JNLP for this application publicly available so we could check it against ours?

2909966

The JNLP is at:

http://services.sportsoptions.com/SO/SO-client.jnlp

Just so you know, this JNLP requests all permissions, but you can of course view the JNLP without giving it the permissions.

Does your JNLP work on some Macs?  This one installs the correct icon on Windows, Linux, and some Macs, but not on all Macs.

Vijayasri

Hi,

Did you find a solution to the issue?

I am facing the same problem on macbook pro (Yosemite 10.10.2) with JRE 8 u45. Just the desktop shortcuts are incorrect icons. At other places like Java cache viewer, desktop folder, Get Info dialog...the icons are shown correctly.

Thanks,

Vijayasri

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Nov 5 2003
Added on Sep 24 2003
6 comments
1,787 views