OraFAQ Forum: SQL & PL/SQL » Oracle - Word bookmark

Home » SQL & PL/SQL » SQL & PL/SQL » Oracle - Word bookmark (64bit)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle - Word bookmark [message #586982]

Wed, 12 June 2013 04:18

wolfking
Messages: 99
Registered: May 2013

Member

Hello everyone,

I have opened this topic just to get your ideas which would maybe guide me.
I am actually collecting data from Oracle and create bookmarks on a word document which correspond to these data and auto-complete it.

I had not any important problem until that I had a case where I do not know the number of data I am going to get in the end.
So I would like to know if you guys have an idea on how to solve this problem.
I do not know how much bookmarks I should create as I don't know the number of rows I am going to get after executing my query.

Thanks in advance,

Report message to a moderator

Re: Oracle - Word bookmark [message #586986 is a reply to message #586982]

Wed, 12 June 2013 04:40

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

We have no idea of what you have and where the problem is.
Is this a design problem?
Is this a SQL problem?
Is this a programming language problem? Which language?
What is your Oracle version?
...

Note that "create bookmarks in a Word document" has nothing to do with Oracle unless you can define it in Oracle words.

Regards
Michel

Report message to a moderator

Re: Oracle - Word bookmark [message #587015 is a reply to message #586986]

Wed, 12 June 2013 07:28

wolfking
Messages: 99
Registered: May 2013

Member

The bookmark that I create takes its information from the database.
I am writing the variable with the same name of bookmark and the system corresponds them.

Select
name "FULL_NAME" --> its bookmark on the word document is FULL_NAME

but how to react when I do not know number of rows I am getting, for ex:

Select
Assistants "Assistant_name" --> If there are more than 1 assistant I should create another bookmark automatically

well this is my situation...

Report message to a moderator

Re: Oracle - Word bookmark [message #587017 is a reply to message #587015]

Wed, 12 June 2013 07:30

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Add a sequence number to every bookmark?

Report message to a moderator

Re: Oracle - Word bookmark [message #587018 is a reply to message #587017]

Wed, 12 June 2013 07:32

wolfking
Messages: 99
Registered: May 2013

Member

Well I do create the bookmark on Word Document. So how would I do that on Word?
The bookmarks are totally done from Word so I do not have a query or smthing special for Word to create its own bookmarks? maybe is that what I need?

Report message to a moderator

Re: Oracle - Word bookmark [message #587019 is a reply to message #587018]

Wed, 12 June 2013 07:35

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Still don't understand your actual problem.
Quote:

Is this a design problem?
Is this a SQL problem?
Is this a programming language problem? Which language?
What is your Oracle version?

Regards
Michel

Report message to a moderator

Re: Oracle - Word bookmark [message #587024 is a reply to message #587019]

Wed, 12 June 2013 07:44

wolfking
Messages: 99
Registered: May 2013

Member

o.k let me try to be more clear,

There are two things :

Oracle Database
Word Document
A web interface

The aim is to create standard letters from the information on DB.
For example, in the left part of letter its writen: FROM TO : Mr. Bla Bla
this Mr. Bla Bla I am getting it from database with a query : select ownerName from owners where ownerkey = PARENTKEY
The parentkey comes automatically from the web interface, it gets the ownerkey and replace it so the query works

how was I getting my oracle version? damn..

Report message to a moderator

Re: Oracle - Word bookmark [message #587026 is a reply to message #587024]

Wed, 12 June 2013 07:45

wolfking
Messages: 99
Registered: May 2013

Member

I don't know if it is a sql problem or smthing else, that is what I am lookin for

Report message to a moderator

Re: Oracle - Word bookmark [message #587028 is a reply to message #587024]

Wed, 12 June 2013 07:47

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

OK, I understand you have a word document with variable fields and you get the values for these fields from the Oracle database.
Now what is the problem you are trying to solve?

Quote:

how was I getting my oracle version?

select * from v$version;

Regards
Michel

Report message to a moderator

Re: Oracle - Word bookmark [message #587030 is a reply to message #587028]

Wed, 12 June 2013 07:49

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Could you post an example? Maybe a Word document screenshot and Oracle test case. I have difficulties in understanding what you are doing.

Report message to a moderator

Re: Oracle - Word bookmark [message #587033 is a reply to message #587028]

Wed, 12 June 2013 07:51

wolfking
Messages: 99
Registered: May 2013

Member

O.K
Until now I always had situation where the number of rows I was getting for a bookmark was NOT important.
If there were two owners, I could list them under the same bookmark.
However now, I should add a signature bookmark for each row that I get.
If I try to adapt it to the example I just gave you:

FROM TO : MR. Bla Bla
FROM TO : MR. Blba bla2
FROM TO : MR. Bla Bla
.
. and so on...

I do not know the number of rows I'll get but I need a specific bookmark for all of them, I can not list them under the same bookmark like
FROM TO: Mr. Bla
Mr. Bla Bla2
Mr. Bla Bla3
This was easier, but now I need what I have shown before.

thanks

Report message to a moderator

Re: Oracle - Word bookmark [message #587034 is a reply to message #587033]

Wed, 12 June 2013 07:52

wolfking
Messages: 99
Registered: May 2013

Member

ok wait, I'll get a screenshot

Report message to a moderator

Re: Oracle - Word bookmark [message #587035 is a reply to message #587034]

Wed, 12 June 2013 07:53

wolfking
Messages: 99
Registered: May 2013

Member

hmmm do I need a link to add a pic? pff

Report message to a moderator

Re: Oracle - Word bookmark [message #587036 is a reply to message #587035]

Wed, 12 June 2013 07:54

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Click the "Reply" button (bottom right corner of every message. In there, you'll see an option to upload a file.

Report message to a moderator

Re: Oracle - Word bookmark [message #587038 is a reply to message #587035]

Wed, 12 June 2013 07:56

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Just click on "Reply" button (do not use the Quick field at bottom of this page) then on "Upload file" below the text field and then on "Insert image into message body".

Regards
Michel

[Updated on: Wed, 12 June 2013 07:57]

Report message to a moderator

Re: Oracle - Word bookmark [message #587042 is a reply to message #587038]

Wed, 12 June 2013 08:00

wolfking
Messages: 99
Registered: May 2013

Member

This is the word document screenshot
As you can see I have variable NomInv NomInv2 NomInv3...and NomPreInv1 NomPreInv2....I do not know the number of this names before
/forum/fa/10863/0/

/forum/fa/10863/0/

[mod-edit: imaged inserted into message body by bb]

Attachment: testcapture.JPG
(Size: 57.10KB, Downloaded 1183 times)

[Updated on: Fri, 28 June 2013 11:14] by Moderator

Report message to a moderator

Re: Oracle - Word bookmark [message #587044 is a reply to message #587042]

Wed, 12 June 2013 08:01

wolfking
Messages: 99
Registered: May 2013

Member

And this is the worsth queries that I use

I created queries for Owners 1-2 3-4 4-5 6-7 ..but for example, if there are 8, it wont work
/forum/fa/10864/0/

/forum/fa/10864/0/

[mod-edit: imaged inserted into message body by bb]

Attachment: Capture2.JPG
(Size: 191.39KB, Downloaded 1248 times)

[Updated on: Fri, 28 June 2013 11:16] by Moderator

Report message to a moderator

Re: Oracle - Word bookmark [message #587045 is a reply to message #587042]

Wed, 12 June 2013 08:01

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

But I still don't see the problem with Oracle.
Post a description of your tables.

Regards
Michel

Report message to a moderator

Re: Oracle - Word bookmark [message #587050 is a reply to message #587045]

Wed, 12 June 2013 08:05

wolfking
Messages: 99
Registered: May 2013

Member

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit

I am looking for a way to fix this problem, with WORD or ORACLE

Report message to a moderator

Re: Oracle - Word bookmark [message #587051 is a reply to message #587050]

Wed, 12 June 2013 08:13

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Michel Cadot wrote on Wed, 12 June 2013 15:01

But I still don't see the problem with Oracle.
Post a description of your tables.

Regards
Michel

Report message to a moderator

Re: Oracle - Word bookmark [message #587056 is a reply to message #587051]

Wed, 12 June 2013 08:23

wolfking
Messages: 99
Registered: May 2013

Member

Dude there are a lot of tables, just asking you some ideas.
I tried to explain the situation, I need some advices on how to resolve it, maybe it should be done via Word

Report message to a moderator

Re: Oracle - Word bookmark [message #587057 is a reply to message #587056]

Wed, 12 June 2013 08:27

wolfking
Messages: 99
Registered: May 2013

Member

lets say that way, I want create bookmarks on a Word Document with ORACLE query?

Report message to a moderator

Re: Oracle - Word bookmark [message #587058 is a reply to message #587057]

Wed, 12 June 2013 08:31

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

post an example of some bookmark on a Word Document.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Oracle - Word bookmark [message #587059 is a reply to message #587057]

Wed, 12 June 2013 08:31

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

atirtil wrote on Wed, 12 June 2013 15:27

lets say that way, I want create bookmarks on a Word Document with ORACLE query?

That's like saying "I want to eat lasagne with a power drill.". A complete goal / tool mismatch.

Report message to a moderator

Re: Oracle - Word bookmark [message #587060 is a reply to message #587059]

Wed, 12 June 2013 08:34

wolfking
Messages: 99
Registered: May 2013

Member

Ok Thomas, would you have some other advices on resolving my problem if I could explain enough clear?

Report message to a moderator

Re: Oracle - Word bookmark [message #587061 is a reply to message #587060]

Wed, 12 June 2013 08:38

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I am looking for a way to fix this problem, with WORD or ORACLE
use WORD since it is less complicated than Oracle

Report message to a moderator

Re: Oracle - Word bookmark [message #587063 is a reply to message #587061]

Wed, 12 June 2013 08:46

wolfking
Messages: 99
Registered: May 2013

Member

thanks finally an advice Smile

Smile

I think, I'll go that way

Report message to a moderator

Re: Oracle - Word bookmark [message #587064 is a reply to message #587063]

Wed, 12 June 2013 08:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

what is a bookmark?

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: Oracle - Word bookmark [message #587068 is a reply to message #587064]

Wed, 12 June 2013 08:56

wolfking
Messages: 99
Registered: May 2013

Member

mark a document or a specific place in a document for later retrieval. Nearly all Web browsers support a bookmarking feature that lets you save the address (URL) of a Web page so that you can easily re-visit the page at a later time.
In a word document, it means you can just go find the bookmarked places easier.

Report message to a moderator

Re: Oracle - Word bookmark [message #587070 is a reply to message #587068]

Wed, 12 June 2013 08:58

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

atirtil wrote on Wed, 12 June 2013 06:56

mark a document or a specific place in a document for later retrieval. Nearly all Web browsers support a bookmarking feature that lets you save the address (URL) of a Web page so that you can easily re-visit the page at a later time.
In a word document, it means you can just go find the bookmarked places easier.

what does any of above have to do with Oracle RDBMS?

Report message to a moderator

Re: Oracle - Word bookmark [message #587075 is a reply to message #587070]

Wed, 12 June 2013 09:05

wolfking
Messages: 99
Registered: May 2013

Member

well I tried to explain it in my previous messages if you check

Report message to a moderator

Re: Oracle - Word bookmark [message #587076 is a reply to message #587075]

Wed, 12 June 2013 09:07

Michel Cadot
Messages: 68765
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Yes you try but, as Blackswan, I still don't understand.
Oracle contains rows.
It knows nothing about your Word document.
It knows nothing about the relation you want to make between its rows and your Word document.

Regards
Michel

Report message to a moderator

Re: Oracle - Word bookmark [message #587079 is a reply to message #587075]

Wed, 12 June 2013 09:16

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

atirtil wrote on Wed, 12 June 2013 07:05

well I tried to explain it in my previous messages if you check

post SQL & results that show some detail regarding either this Word Document or the BookMark.

Report message to a moderator

Re: Oracle - Word bookmark [message #587190 is a reply to message #587079]

Thu, 13 June 2013 01:40

Littlefoot
Messages: 21825
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

A MS Word bookmark, as I know it, is a way to quickly visit previously marked text. (I created a short walkthrough; have a look at the image attached, if you are interested. Won't help at all in this very problem, but a little bit of education won't hurt).

However, reviewing @atirtil's screenshots, it doesn't look like a bookmark but rather a mail merge problem. For example: you are getting married and want to invite 200 people. You could do that copy/pasting the same text 200 times and replacing previous name with a new one, but that's a boring and tedious job. Therefore, you create a list of people (in any text editor, including MS Word or even Excel), create a template and simply "merge" that template with the list, and there you are - 200 letters ready to be printed.

Now: source for the list could be an Oracle database table. Using ODBC, it should be possible to merge SELECT's results with a Word document. Personally, I've never done that. Here are Google search results. I took a look at some of them, but can't decide which one would be the "best".

On the other hand, maybe it is not about mail merge at all so I missed the point completely. Either way, I don't have much to offer, sorry.
/forum/fa/10869/0/

/forum/fa/10869/0/

[mod-edit: messaged inserted into image body by bb]

Attachment: word_bookmark.jpg
(Size: 186.97KB, Downloaded 1239 times)

[Updated on: Fri, 28 June 2013 11:17] by Moderator

Report message to a moderator

Previous Topic:	Can we pass REF_CURSOR to externel procedure
Next Topic:	add parenthesis to query

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Aug 09 07:16:52 CDT 2025