hi, how to upload data into MS Word?

asked 13 Nov '12, 05:38

Alexandr's gravatar image

Alexandr
16
accept rate: 0%

there exists such a function?

(13 Nov '12, 05:39) Alexandr

Hi Alexandr,

No, Formspider does not have a function to export data to MS Word yet.

Regards, Ibrahim

link

answered 13 Nov '12, 05:47

Ibrahim%20Sandalli's gravatar image

Ibrahim Sand... ♦♦
1.5k5
accept rate: 25%

Hi, all clear

link

answered 13 Nov '12, 09:12

Alexandr's gravatar image

Alexandr
16
accept rate: 0%

You can tell me how to call the stored procedure by clicking on the button? Here's the procedure:

procedure test is
begin htp.p('test'); end;

when I run the button displays an error

link

answered 13 Nov '12, 09:27

Alexandr's gravatar image

Alexandr
16
accept rate: 0%

Hi Alexandr,

Why do you use htp in a Formspider action? Can you tell us what you are trying to accomplish? So that we can help you better.

link

answered 14 Nov '12, 00:40

Ugur%20Kocak's gravatar image

Ugur Kocak ♦
5616
accept rate: 23%

Hi. I need the output to ms word:

create or replace procedure ExportToWord
is
begin
OWA_UTIL.MIME_HEADER ('Content-Type:application/vnd.ms-word;charset=utf-8', false);
htp.print('Content-Disposition:attachment;filename="test.doc"');
OWA_UTIL.HTTP_HEADER_CLOSE;
htp.p('<table>');
htp.p('<tr><td>doc_name</td><td>status</td><td>description</td></tr>');
for i in (select id, doc_name, status, description from test) loop
htp.p('<tr><td>'||i.doc_name||'</td>');
htp.p('<td>'||i.status||'</td>');
htp.p('<td>'||i.description||'</td></tr>');
end loop;
htp.p('</table>');
end ExportToWord;

link

answered 14 Nov '12, 01:40

Alexandr's gravatar image

Alexandr
16
accept rate: 0%

edited 14 Nov '12, 01:41

I am not familiar to mod_plsql. I think you should first enable mod_plsql in your database. So that your database can generate and serve HTTP responses.

http://docs.oracle.com/cd/B19306_01/server.102/b14337/concept.htm

If you can generate the word file and download it from a URL with mod_plsql, then you can use this URL with a Formspider hyperLink component.

link

answered 14 Nov '12, 03:03

Ugur%20Kocak's gravatar image

Ugur Kocak ♦
5616
accept rate: 23%

OK, I'll try to deal with mod_plsql. Thanks.

link

answered 14 Nov '12, 04:08

Alexandr's gravatar image

Alexandr
16
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×2
×1

Asked: 13 Nov '12, 05:38

Seen: 1,815 times

Last updated: 14 Nov '12, 04:08


© Copyright Gerger 2017