I'm studing OCI, and got a problem.

I wrote a small program that calls oracle procedure and prints the
result.

The program code is posted to pastebin:

http://pastebin.ca/364875

The text of oracle procedure is:

create or replace PROCEDURE TEST ( param1 IN VARCHAR2, param2 OUT
VARCHAR2)
AS
BEGIN
param2 := param1;
END TEST;

But while running it, i got segfault. It is very strange, i can't
understand why. Can anybody help me to find a error?

Victor Polukcht <vpolukcht@gmail.com> wrote:
> I'm studing OCI, and got a problem.
>
> I wrote a small program that calls oracle procedure and prints the
> result.
>
> But while running it, i got segfault. It is very strange, i can't
> understand why. Can anybody help me to find a error?

Use a debugger to analyze the core dump.

If the segmentation fault is in your code, fix it.

If the segmentation fault is in Oracle's code, open a service request.

Yours,
Laurenz Albe

Victor Polukcht wrote:

> I'm studing OCI, and got a problem.
>
> I wrote a small program that calls oracle procedure and prints the
> result.
>
> The program code is posted to pastebin:
>
> http://pastebin.ca/364875

Why not here?

> But while running it, i got segfault. It is very strange, i can't
> understand why. Can anybody help me to find a error?

At least a stack trace would be helpful.

Mathias

On Feb 20, 8:57 pm, Mathias Waack <M.Wa...@gmx.de> wrote:
> Victor Polukcht wrote:
> > I'm studing OCI, and got a problem.
>
> > I wrote a small program that calls oracle procedure and prints the
> > result.
>
> > The program code is posted to pastebin:
>
> >http://pastebin.ca/364875
>
> Why not here?

I think most of readers use web-interface, so it's not a problem to
open a link. Btw, there are 112 lines of code.

>
> > But while running it, i got segfault. It is very strange, i can't
> > understand why. Can anybody help me to find a error?
>
> At least a stack trace would be helpful.

Actually i'm not looking for suggestions how to debug. The problem is
that i was doing everything according to dauby OCI documentation and
examples from companion cdrom. But that code doesn't work. May be you,
or somebody else can give me a small working example of binding
strings and calling pl/sql procedures?

> Mathias

"Victor Polukcht" <vpolukcht@gmail.com> wrote in
news:1171995323.698812.179310@t69g2000cwt.googlegr oups.com:

> On Feb 20, 8:57 pm, Mathias Waack <M.Wa...@gmx.de> wrote:
>> Victor Polukcht wrote:
>> > I'm studing OCI, and got a problem.
>>
>> > I wrote a small program that calls oracle procedure and prints the
>> > result.
>>
>> > The program code is posted to pastebin:
>>
>> >http://pastebin.ca/364875
>>
>> Why not here?
>
> I think most of readers use web-interface, so it's not a problem to
> open a link. Btw, there are 112 lines of code.
>
>>
>> > But while running it, i got segfault. It is very strange, i can't
>> > understand why. Can anybody help me to find a error?
>>
>> At least a stack trace would be helpful.
>
> Actually i'm not looking for suggestions how to debug. The problem is
> that i was doing everything according to dauby OCI documentation and
> examples from companion cdrom. But that code doesn't work. May be you,
> or somebody else can give me a small working example of binding
> strings and calling pl/sql procedures?
>
>> Mathias
>

check out http://asktom.oracle.com for many fine coding examples