This content has been marked as final. Show 5 replies
Not seeing the problem, using xp pro SP3 ...
Same result when adding oname=...
$ wrap iname=mysql.sql PL/SQL Wrapper: Release 18.104.22.168.0- Beta on Sat Aug 06 18:30:46 2011 Copyright (c) 1993, 2009, Oracle. All rights reserved. Processing mysql.sql to mysql.plb $ type mysql.plb CREATE OR REPLACE FUNCTION get_date_string wrapped a000000 b2 abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd abcd 8 6f ae nFyz0XQ0hI8R8Iy+Nwi7ZbmBWekwg8eZgcfLCNL+XlquYvSuoVah8JbRPpdHDOrnwLK9spte 58d0wDO4dGUJuHSLwMAy/tKGrPJGzsbWFCGs79ZMdoRxMo53THH1EHNz9e83Z0zr7Nk9cumv VSoUHBT9LHbTXSnBSNempgzqLFE= / $ sqlplus /nolog connect ... passwd ... @mysql.plb Function created. SQL> select get_date_string from dual; GET_DATE_STRING ---------------- 06-AUG-2011
What are you using to create your .sql file? notepad?
Edited by: clcarter on Aug 6, 2011 6:44 PM
add compile and test
I create my files in Notepad.
EDIT: Wrap doesn't work when I use SQLDeveloper to edit the sql file.
I have tried updating my path to be only the XE install directory:
echo %PATH%But the output file still is not created.
I wonder if the problem is to do with me running Windows 7?
Edited by: Graham on Aug 6, 2011 10:24 PM
Could be the issue, although I'm not finding any relevant support notes on the wrap utility. One mentions the 10g client doesn't include wrap.exe, another on HP OpenVMS needs an environment setting for wrap to work, that's it. I'm on xp pro so can't help much to verify if that is the trouble or not.
running Windows 7?
So maybe something in the .sql file might be interfering- what about starting up a brand new notepad session and try pasting in the DDL, might be some non-printing characters in the file introduced by SQLDeveloper that keep wrap.exe from working.
doesn't work when I use SQLDeveloper to edit the sql file
Only other possibility I can think of for Windows, could be permissions related if your computer user isn't in local admins and/or the ORA_DBA group. I have a hard enough time remembering how to get to local groups on xp no idea how to check that for win7.