Driver problem

Hi all,
I used IBM's driver and got the following error message:
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
After I switched to ojdbc14.jar driver I got another error message:
java.sql.SQLException: ORA-01008: not all variables bound

Can someone point out the correct oracle driver - where do I find it in BIRT. I use Oracle 10 and Birt 2.1.2......

Thanks,
vaishnavi

Find more posts tagged with

Comments

mwilliams

Hi vaishnavi,

I'm pretty sure the ojdbc14.jar is the correct one. Where are you placing the driver?

Rupesh_Mh

HI dear i guess it not a driver problem if u r giving call to a store procedure then u must have not defined a out/in parameter in ur procedure at backend
define one and pass same parameters as ur procedure takes.
it will work if not other problem.

vaishnavi

Hi,
Thanks for your reply..
I'm placing the driver at
D:birt-report-designer-all-in-one-2.1.2pluginsorg.eclipse.birt....oda.jdbcdrivers path.
As per my search I also found that we are not able to run report by calling procedure in BIRT 2.1 which contains parameters as REF_CURSOR.

Regards,
Vaishnavi

Rupesh_Mh

Ok so u got ur solution but can u plz help me i have stucked with creating table with borders in birt ofcourse

thnks in adv.

mwilliams

Hi Rupesh_Mh,

What problem are you having with borders?

Rupesh_Mh

sir/madam,
when i create tables with borders(even with thickness of 1 px.) and excport it to excel those borders become much thicker in exported excel file, i am also facing problem with tables with scroll bars plz give me some solution

vaishnavi

Hi Michael,
The driver i'm using ojdbc14.jar is correct one..I put others drivers as well as i mentioned in the above path but still I'm not able to create dataset in BIRT 2.1.2 by calling procedure with these drivers,I also found that BIRT 2.1 doesnt support to REF_CURSOR so is there any other way to call procedure?

Do reply your suggession.

Thanks
Vaishnavi