[odb-users] calling oracle procedure with odb

[roberto minarelli]

Hi odb-users,
I am trying to call a very simple procedure that has only one parameter as
out param

I tried as follows, following something found in the archive

#pragma db view query("CALL my_procedure(?)")
struct my_procedure
{
  unsigned short myvalue;
};

then in the code part I wrote

......
            struct get_freetg xtg;
            using query1=odb::query<get_freetg>;
            transaction t(db->begin());
            db->query<get_freetg>(&xtg.tg);
            t.commit();
.....

But this does not works at all

I guess I made some mistake, but I cannot figure where

Thanks for help

Best regards

Roberto Minarelli Della Valle