tag:blogger.com,1999:blog-4493586256376036286.post2046630269920441985..comments2023-10-05T00:35:26.090-07:00Comments on Saubhik's Blog On Oracle SQL, PL/SQL, DBA, PostgreSQL, AWS, DynamoDB and Python: Reading and Writing Excel file (.xls) From PL/SQL Using COM - PART ISaubhik Banerjeehttp://www.blogger.com/profile/12352977715615160656noreply@blogger.comBlogger12125tag:blogger.com,1999:blog-4493586256376036286.post-72813906456233257612015-12-30T23:12:46.849-08:002015-12-30T23:12:46.849-08:00I have follow this article.
If see ORA-06502: PL/...I have follow this article.<br /><br />If see ORA-06502: PL/SQL: numeric or value error: character string buffer too small<br /><br />Solution: redefine error_description varchar2(1000)<br /><br />If see error: Microsoft canot access excel file 'C:\Exampe.xls' <br />There are several possible reasons:<br />•The file name or path does not exist.<br />•The file is being used by another program.<br />•The workbook you are trying to save has the same name as a currently open workbook.<br />Solution:<br /> Create directory "C:\Windows\SysWOW64\config\systemprofile\Desktop " (for 64 bit Windows) or "C:\Windows\System32\config\systemprofile\Desktop " (for 32 bit Windows)<br />Ngố rừnghttps://www.blogger.com/profile/17098994485072700777noreply@blogger.comtag:blogger.com,1999:blog-4493586256376036286.post-90638004456771377372014-02-11T19:03:57.062-08:002014-02-11T19:03:57.062-08:00Please check the value length in given excel and v...Please check the value length in given excel and variables declared in procedural block, this would resolve your concernLUVhttps://www.blogger.com/profile/09885508786890222695noreply@blogger.comtag:blogger.com,1999:blog-4493586256376036286.post-17427418289146476872012-05-25T22:41:41.567-07:002012-05-25T22:41:41.567-07:00Hi,
Please Help, I am using oralce 10g and saved t...Hi,<br />Please Help, I am using oralce 10g and saved the excel sheet(Example.xlsx) in drive E. Ihave tried a lot but unable to find a solution. It will be kind enough of you.Arjunhttps://www.blogger.com/profile/05033450701504890077noreply@blogger.comtag:blogger.com,1999:blog-4493586256376036286.post-83887663471940627012012-05-20T01:48:08.726-07:002012-05-20T01:48:08.726-07:00Hi,
Thnx for it,
I am getting this as an output
&q...Hi,<br />Thnx for it,<br />I am getting this as an output<br />"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""<br />Creating Excel application...<br />Invoking Workbooks...<br />Opening Excel file E:\Example.xls ...<br />Closing workbook and quitting...<br />Closing workbook...<br />DECLARE<br />*<br />ERROR at line 1:<br />ORA-06502: PL/SQL: numeric or value error: character string buffer too small<br />ORA-06512: at "SCOTT.ORDCOM", line 289<br />ORA-06512: at "SCOTT.ORDEXCELSB", line 452<br />ORA-06512: at line 42<br />ORA-06502: PL/SQL: numeric or value error: character string buffer too small<br />"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""<br /><br />Please help me .....Arjunhttps://www.blogger.com/profile/05033450701504890077noreply@blogger.comtag:blogger.com,1999:blog-4493586256376036286.post-20661963242774006172012-05-04T01:30:49.841-07:002012-05-04T01:30:49.841-07:00Also, You can use Oracle Heterogeneous Service for...Also, You can use Oracle Heterogeneous Service for much easier readings.<br />You can find more about this in OTN. https://forums.oracle.com/forums/ann.jspa?annID=1535Saubhik Banerjeehttps://www.blogger.com/profile/12352977715615160656noreply@blogger.comtag:blogger.com,1999:blog-4493586256376036286.post-8335228104397698422012-05-04T01:22:41.170-07:002012-05-04T01:22:41.170-07:00Yes. That should be possible, but currently not in...Yes. That should be possible, but currently not included in the package. <br />The work around may be looping through all 65000 rows (1..65000) and exit as soon as some mandatory cell (e.g. Primary Key) is blank (null).Saubhik Banerjeehttps://www.blogger.com/profile/12352977715615160656noreply@blogger.comtag:blogger.com,1999:blog-4493586256376036286.post-46062313050303502272012-05-04T01:17:37.219-07:002012-05-04T01:17:37.219-07:00You can not use this dll in *INX platform. Read th...You can not use this dll in *INX platform. Read the Oracle COM Automation guide.Saubhik Banerjeehttps://www.blogger.com/profile/12352977715615160656noreply@blogger.comtag:blogger.com,1999:blog-4493586256376036286.post-77143851024393345892012-04-30T22:33:03.202-07:002012-04-30T22:33:03.202-07:00Hi,
How do I use this dll on an AIX Unix server?
...Hi,<br /><br />How do I use this dll on an AIX Unix server?<br /><br />Thanks,<br /><br />RaviUnknownhttps://www.blogger.com/profile/04117667735880800141noreply@blogger.comtag:blogger.com,1999:blog-4493586256376036286.post-66095890894434725092012-04-26T04:34:41.280-07:002012-04-26T04:34:41.280-07:00thank you Saubhik.
Now i'm able to run the co...thank you Saubhik.<br />Now i'm able to run the code.<br /><br />Is there any chance of getting total number of rows present in a xls file?<br />So that by using this count, i can read the lines from xls file using loop.<br /><br />Thank youRadhika Poduguhttps://www.blogger.com/profile/06041561294907998562noreply@blogger.comtag:blogger.com,1999:blog-4493586256376036286.post-86761306376582664652012-04-25T03:32:59.978-07:002012-04-25T03:32:59.978-07:00This should be on the companion CD of Oracle Insta...This should be on the companion CD of Oracle Installer.Saubhik Banerjeehttps://www.blogger.com/profile/12352977715615160656noreply@blogger.comtag:blogger.com,1999:blog-4493586256376036286.post-58613634712914768112012-04-24T11:45:09.414-07:002012-04-24T11:45:09.414-07:00Hi Saubhik,
Its really useful information regardin...Hi Saubhik,<br />Its really useful information regarding xls files loading into database.<br />Could you please tell me how to locate the below file ?<br />Or can you post the code please ?<br /><br /> comwrap.sqlRadhika Poduguhttps://www.blogger.com/profile/06041561294907998562noreply@blogger.comtag:blogger.com,1999:blog-4493586256376036286.post-8674067871600458942011-08-31T06:15:16.961-07:002011-08-31T06:15:16.961-07:00Hi Saubhik,
First thanks for you code. I spent ...Hi Saubhik,<br /> First thanks for you code. I spent a lot of time lookig for this and finally I found oyur blog.<br /><br />I'm doing some test and I got the following errors in the dbms output:<br /><br />Creating Excel application...<br />COM-0004: The registered CLSID for the ProgID is invalid.<br />Invoking Workbooks...<br />COM-0004: The registered CLSID for the ProgID is invalid.<br />Invoking Add to WorkBooks...<br />COM-0002: Invalid Token or no interface for token<br /><br />I tried to register the orawpcom10.dll on the server but I could not.<br /><br />Any idea?<br /><br />Thanks again,<br />JavierFº Javierhttps://www.blogger.com/profile/18142753100881445974noreply@blogger.com