Skip to Main Content
Forums

Berkeley DB Family

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

C++Builder6.0 Link Error

561922Mar 26 2007 — edited Aug 22 2007
Hill.
The Kerbeley DB Version is 4.0.5.20
The OS is Microsoft XP Professional Service Pack 2
Development Tool is Borland C++Builder 6.0

Source code:
------------------------------------------------------------------------------
#include <iostream.h>
#include "db_cxx.h"
using namespace std;
int main(int argc, char *argv[])
{
Db db(NULL, 0);
//std::cout << "Hello!" << std::endl;
db.close(0);
return 0;
}

------------------------------------------------------------------------------
The following error happed when program is linked.

[Linker Error] Unresolved external 'Db::~Db()' referenced from F:\OWNERDB\EEEE.OBJ
[Linker Error] Unresolved external 'Db::Db(DbEnv *, unsigned int)' referenced from F:\OWNERDB\EEEE.OBJ

TIA.
Peter

Message was edited by:
user558919

Comments

odie_63
Answer

Hi,

You can do that by passing the head element to the second XMLSequence. That way you maintain the correlation between the parent and its children :

select extractvalue(value(head), '/Servicio/Nombre') as srv_nombre


     , extractvalue(value(head), '/Servicio/Descripcion') as srv_desc


     , extractvalue(value(head), '/Servicio/Activo') as srv_activo


     , extractvalue(value(head), '/Servicio/Version') as srv_version


     , extractvalue(value(detail), '/Metodo/Nombre') as met_nombre


     , extractvalue(value(detail), '/Metodo/Activo') as met_activo


     , extractvalue(value(detail), '/Metodo/Version') as met_version


from arwt_ws_return x


   , table(xmlsequence(extract(x.x_xmldoc, '/arrayOfServicio/Servicio'))) head


   , table(xmlsequence(extract(value(head), '/Servicio/MetodosEntity/Metodo'))) detail


;

Please also note that :

- you don't need a descendant axis (//) if you know the exact path

- you don't need to go down to the text() node if you're using extractvalue

Hope that helps.

Marked as Answer by 1019748 · Sep 27 2020
1019748

Thank you so much Odie.

That really helps!

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 19 2007
Added on Mar 26 2007
#berkeley-db
16 comments
5,341 views