Monday, November 30, 2009

Interesting APEX with dblink issue

We recently ran in to a problem when connecting across a database link to a Postgres database.  The query looked like this
select "column1", "column2"
  from "my_schema"."my_long_named_view"@my_db_link
It works fine from sql*plus and sql Developer, but when running the same query in Application Express (in an app or in the SQL Workshop) we got this error:
ORA-28500: connection from ORACLE to a non-Oracle system returned this message: [Generic Connectivity Using ODBC]DRV_QspecDescribe: DB_ODBC_RECORD (189): ; [OpenLink][ODBC][PostgreSQL Server] current transaction is aborted, commands ignored until end of transaction block (SQL State: S1000; SQL Code: 1) ORA-02063: preceding 2 lines from MY_DB_LINK
Dave Rydzewski came up with the solution.  Shorten the name of the view in Postgres and change the query to look like this (note two fewer double quotes "):
select "column1", "column2"
  from "my_schema.short_v"@my_db_link
I'm still not sure what APEX does to make it blow up.  I wonder how many people use APEX with a db link to Postgres.

Tuesday, November 24, 2009

VMware pc2mac

I thought tonight was going to be the night.  I purchased a macbook pro about 6 weeks ago.  I've slowly been getting familiar with the mac, and realizing that I'll probably still need a PC image at least occasionally.  Last night I installed VMware Fusion for the mac (nice that it's called Fusion, that way it almost has something to do with this Oracle blog).  Tonight I was to create the image from my work laptop and test it out on the macbook.  Alas, try as I might, I still don't have an image.  This is my story.

I read the VMware readme (yep, I do that kind of thing).  I learned about pc2mac, the utility that lets you stream the image right off your running pc and onto an image on your mac.  I read the guides.  I installed the pc2mac utility on my PC, restarted my PC and the VMware Fusion PC Migration Agent screen opened right up.  I ran VMware on the mac and followed the instructions, typed in the four-digit passcode, the administrator password, clicked continue, and got an error:

Converter failed to connect to remote machine.
An error occured while transferring data
I tried a few times, but did not get any further.  I decided to come back later, but first, I returned to the PC to close out the migration agent.  Noticing the checkbox "Run the VMware Fusion PC Migration Agent Every time I start my PC", I realized that I probably don't want this to every time.  I unchecked the box.

Returning later to try again, I could not find a way to start up that migration assistant.  I googled.  I rebooted, re-installed pc2mac, rebooted, uninstalled, rebooted, reinstalled, rebooted.  Mind you, this was the PC I was rebooting--not a quick affair, much like this blog post.  I'll cut to the chase, even an uninstall and reinstall would not bring up that screen again.  I finally found the trick though.  Edit the registry:

HKEY_CURRENT_USER > Software > VMware, Inc. > PC Migration Agent
Edit RunAtStartup and change from 0 to 1.

Of course, the change from 0 to 1 was just a guess, but it worked.

Now, at 11:06pm, I'm back to having a pc2mac utility that will run the first screen, but it still does not work.  Now that's progress.  Oh, and my wife just said, "How do I find your blog?"  Good night everybody.

[Update: 25 Nov 2009, 4:53pm]  I also had an issue logging an issue with VMware.  The first problem was that I could not register the product.  The VMware registration website kept giving an error that it was not a valid code despite the fact that it was in the email and the product installation accepted it.  I was able to log a customer service issue about not being able to register, but I was not able to log a technical issue without first registering.

I called and spoke with an extremely helpful support rep.  She told me they were having issues with some registration numbers and offered to create the technical ticket for me.  She was so helpful that I went back to the VMware site to drop a note to anyone that would accept it.  This is the note I typed:

I recently purchased VMware Fusion.  I generally know my way around technology, but just registering my VMware software on the website was impossible (truly, as there is currently a bug in your system).  After quite a bit of frustration, though, I finally called and spoke with a support representative.  I'm sorry that did not get her full name, but she created a new SR for me, 1459858086, and it has been assigned to SGARDNER.

This support rep was very helpful, polite and overall reflected very well on VMware.  Though my issue has not been resolved, I had a very positive experience speaking with this rep.  If you have the ability to commend her I hope you will.
That's not bad, right?  Unfortunately, though, it never went anywhere.  The only page I could find a place type the note was here:
The page never allowed me to pick a Country or State.  It just kept showing "loading..." without ever showing a country.  Of course, those fields are mandatory.

Sorry friendly support rep, I'm afraid that note won't make it anywhere.

Wednesday, November 04, 2009

Looking for APEX Developers

I have a client in the northeast of the US. If you are really good with the Oracle DB, pl/sql and APEX, and live or want to move to the US Northeast, send me your info and I'll pass it along. Please send an email with your resume to me (anton) at work (