I May Just Have To Kill Myself....Oracle

I have a stored procedure in Oracle.

I build the sql beautifully to call it with Openquery

"select * from OPENQUERY(MYLink,'DECLARE P_DATE VARCHAR2(20); BEGIN P_DATE := ''15-Sep-2006 17:26:09''; EXEC poPT (P_DATE); COMMIT; End;')

"Server: Msg 7357, Level 16, State 2, Line 1"

"Could not process object 'DECLARE P_DATE VARCHAR2(20); BEGIN P_DATE := '15-Sep-2006 17:26:09'; EXEC poPT(P_DATE); COMMIT; End;'. The OLE DB provider 'MSDAORA' indicates that the object has no columns."

I cannot seem to find away to make this work.

I wanted to return just the record count to make it happy but that did not work either.

The linked server is fine, the grants are fine.

I even tried this as a function in oracle to no avail.

I feel like I am going insane trying to make something that SHOULD BE SIMPLE work.

It's times like this that you really appreciate SQL Server....

Thanks for ANY help with this.